Hello,

I need to update to B a property of all of the objects of certain class which have this property set to A. I could have a great collection of those objects. In SQL I can execute this statement:

UPDATE the_table SET the_field = B WHERE the_field = A;

The only way that I could think to do it in Hibernate is to load the collection of the_table where the_field = A and then execute an update for each element of the collection. On great collections this method will be extermely unefficient.

Could you give me some advice?
Thank you.
Tatiana

I think the best way to do this is using JDBC. You could get the JDBC connection from the Hibernate session via

Connection con = session.connection();