Hi,

I'm developing a web application that requires row-level locks. The application reads and locks a particular record with a "select ... for update" statement. How is this lock cleared if the user cancels the update?

Thanks,
Tom

I discovered that the record level locks are cleared by a commit or a rollback. The next question is what strategy do you use to maintain the connection object on which the lock is held while waiting for the user to proceed with the update or cancel it. You somehow need to maintain that connection to either commit the transaction or roll it back.