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.

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.

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.)

4. 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.