tx.rollback doesn't seems to work

xguo · **Joined:** Thu Jul 14, 2005 7:54 pm **Posts:** 11

Hibernate version:3.0
Database: Oracle 9i

I have 2 session.save(...) calls in 1 transaction, to save 2 objects to database
the first one succeeded and the second one failed and caused an exception, in the exception handler I called tx.rollback. but from the same connection/session, next time I fetch the object, the value has been updated which supposed to be rolled back.
Any ideas?

pksiv · **Posted:** Wed Aug 10, 2005 9:10 am

xguo wrote:

Hibernate version:3.0
Database: Oracle 9i

I have 2 session.save(...) calls in 1 transaction, to save 2 objects to database
the first one succeeded and the second one failed and caused an exception, in the exception handler I called tx.rollback. but from the same connection/session, next time I fetch the object, the value has been updated which supposed to be rolled back.
Any ideas?

make sure that during configuration you are setting the property hibernate.connection.autocommit = false.

gruberc · **Posted:** Thu Aug 11, 2005 7:05 am

It is not a good idea to reuse a session when an exception has occurred.
What happened here is that the first object was still in the session cache.

Christian