I can not search data by rollback!?

, ,
#1

Hi.

I use javaAPI + Tamino ver4.2.1.8 hotfix 835.
I have trouble with I can not search data.

  1. create connection and start transaction (Local Transaction Mode).
  2. I execute some update querys.
  3. I execute rollback and close this connection.
  4. I execute query for search updated data.but no data hit.

I analize this data,
・This updated data is exist.
・Search query , specific “where phrase” is not hit this data ,
but other specific “where phrase” is hit　this data.
・When I recreate “index” , this problem is solved.
・When I load this data from xml file at TII(TaminoInterractiveInterface),
this problem is solved.

What is the cause of the problem?
This problem is Tamino’s BUG?

please help me.

#2

If you execute some update then rollback then the changes are restored to their original form. So surely you need to commit rather than rollback?

I don’ t under how running “recreate index” can solve the problem. When you update via the TII then the update runs in autocommit mode so the update data is visible straight away.

One final point, I would recommend upgrading to Tamino v4.4

hope this helps.

#3

Thank you for your advice!

My problem is that “I can not search the original form data after I rollback”. I want to hit the data no updated.

for example…

  1. this is original data

    123
    456
    …

  2. update and insert and so on.(by Java program)

    123
    789
    000
    …

  3. this transaction rollback.(by Java program)
    (updated data became same original form.)

123 456 ....
  1. search this data.(by TII)

-in this case , I can hit the data.

for $a in input()/aa
where $a/bb = “123”
return $a

result is …

123
456
…

-But this case , I can not hit the data.

for $a in input()/aa
where $a/c = “456”
return $a

result is none.

I recreate “”'s index by SchemaEditor , then , I can search the data.

for $a in input()/aa
where $a/c = “456”
return $a

result is …

123
456
…

I hope to solve hotfix for v4.2.

Thank you.

#4