What is the correct way to use Hibernate to do a rowset update to the database without reading the collection first?

For example, in SQL:
UPDATE EMPLOYEES
SET salary = salary + 10000
WHERE salary < 50000

Is there a direct way to do this in Hiberate, or do I need to drop to a JDBC PreparedStatement to set the WHERE clause variable (in this case, the 50000 is variable)

You can't execute a direct UPDATE with Hibernate, use Session.connection() to get a JDBC connection.

I should add that the tables this would be done on are 1 million plus rows, and the set size anyting from 1 to 50000 in all likelyhood, so reading to a collection, using sets, and then persisting, is potentially way slower than a direct rowset update.

thanks for the quick reply.

Thats why this rare case is not the job of ORM (or Hibernate). Use a Stored Procedure or a direct SQL call. If your application is only rare cases, ORM may not be a good choice.