Hallo,
i'm using JBoss+Hibernate for a database editing application!
I'd like to lock a row when i get it from the database; in this way no one can get this row until the update. But i'd like also to develop a timeout system that release the row after 3 minutes.
Do u have any idea?
Thanx for any help!

Gio

It's not usual to use pessimistic locking in web applications. And there's no way, to say, that you want to lock a record for n seconds. To release the lock, you need to have the connection, which locked the record.

I agree that this is not a good thing to do. However, you should be able to do it by defining a persistent unlockTime property on your class.

When you lock the object, simply set unlockTime. When another transaction tries to obtain the lock, it should retrieve the object, and check that the current timestamp is either null or < the current time.