I am planning to use Hibernate 3.2.2 together with MS SQL Server 2000 for my project. I have a requirement as follows:

When a user selects a record for edit, the record must be locked. If the user does not submit any update within 20 minutes, then the record can be edited by other users after 20 minutes. If the user does submit changes within 20 minutes, then the record is immediately available for edit by other users.

I am not sure Hibernate 3.2.2 together with MS SQL Server 2000 can do this.

If they can, could you please let me know the general ideas or pointers about how to do this?

If they cannot, I am thinking about using two extra fields for the above requirement: one for recording the time a record is read for edit; the other for recording whether the edit operation is finished. Do you think this will work? Please advise.

Thanks in advance!!!

Best,
David