Hello, There is no option to do a SELECT .. FOR UPDATE ... NOT WAIT option in the current JAWS release. Most applications will just want to throw an exception in case a lock could not be acquired to let the user know that the record is being edited. And if you consider a case where you have client waiting for a lock to be released and some database problems occur that cause it to stall it could grow quite quickly with the number of clients waiting for a lock. As we planning for something of a NO WAIT option [as in Oracle] for this? Vinay _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development