Hibernate version: 2.0 final

Dear All,


I am trying to run query like :

"UPDATE Table1 SET Table1.Column = Table1.Column - 10000 Where Table1.Column > 100000;"

Using Hibernate. But I need the query to "follow" the behaviour of Hibernate Transaction (Transaction tx = Session.beginTransaction()) and Hibernate Transaction Commit (tx.commit()). So that the query would never change the database until the Transaction Commit Occured and the Transaction Rollback (tx.rollback()) will reverse the state of the database before the Transaction Commit Happen.

I also need to find out whether my query is changing the database (the Table1.Column > 100000) or not (the Table1.Column < 100000).

Thank you,


Rahmat Bagas Santoso

session.connection().prepareStatement()