Hi -

I am using Hibernate v2.1.7, and I have a question regarding update. Suppose I have a table, User, with numerous records already in the table. And suppose I want to update one of the fields in one of the records in the database. Is there a way to update without loading(retrieving) that record from the database and just updating that individual record.

I am aware of the 'dynamic-update' attribute which will only propagate the updated value, but even with this attribute, you still have to load the object initially. Is there a way to avoid doing this without loading the object? You can do it in pure JDBC, and I assume (or hope) there is a way to do it with Hibernate.

Basically, I want to do something like "update user.name where user.id = id", where I update only the user name and keep all the other fields the same (and not change to nulll)

I've searched the forum and there have been similar posts on this issue, and as well I have read the documentation on updating detached objects, updating, etc.

Any input would be appreciated!

Thanks in advance.

In H3 there are batch update queries. In h2, you can only use direct JDBC

Wow - that was quick. Thanks for the response!

Curious - is there an expected date for a stable release of Hibernate v3.0 ?