Hi,

I have a specific case and I'd like to know if a feature exist in Hibernate to make it work:
I want to connect to a legacy database that has an update_date column in each of its tables. I'd like to use optimistic locking with the version attribute mapped to these columns in my hibernate mapping files, but hibernate shouldn't increment the version numbers by itself because the database has triggers to increment these columns automatically when an update is performed on the data. Is there a way to do this ?

Thanks for your help.

Use a <timestamp> element to describe that column in your mapping files. It will be used for optimistic locking. Pertinent link: http://www.hibernate.org/hib_docs/v3/re ... -timestamp

Of course, it is equivalent to <version type="timestamp"> , but I think the <timestamp> element is cleaner looking. Up to you.

Not only it is cleaner looking, but also I can use it with the attribute generated set to "always". That way Hibernate won't increment the value on insert or update and will let the triggers in the database do so. It looks like this solves my problem.

Thank you very much for your help.