I need to change the status of all Employees that meet certain criteria. This is an administrative function, and I don't need to fetch the Employee objects. Is there a way to do this in Hibernate 2.1 without getting a Collection, iterating through them and changing the status?

In this case, I would think a straight JDBC update statement would be more efficient.

Thanks.

I think straight JDBC would be preferrable in that situation.

Not in 2.1 using HQL.

According to the Hibernate site, Batch processing is/was the empasis for v3.1 and this style of updates is provided for in the 3.1 code-base. See section 14.4 of the Reference Documentation.

Thank you,
Migration to Hibernate 3 will resolve the issue. In the meantime, I'll just do a straight JDBC update.