Hi,

I am new to hibernate. I am using Hibernate 2.8. And I have a requirement that I need to update multiple records in a table using hibernate. Just as we write a simple SQL query to update multiple records - Update <table> set <column> = <value> where <field> in (value1,value2). How do i perform the above task using hibernate.

Thanks in advance.

Hibernate 3 supports DML-style HQL (i.e. UPDATE ...); unfortunately for you, H2 does not. Your choices are:
- Upgrade to H3;
- Retrieve and iterate over a list and update each;
- Use SQL thru a JDBC call (note: you can get the connection from Hibernate [Session.connection]).

Curtis ...