If I've got a web application that is doing a SELECT FOR UPDATE for
one user. When subsequent user comes tries to do a SELECT FOR UPDATE,
my application just hangs until the lock is released. I've tried using
the "NOWAIT" clause at the end of the statement, but that doesn't
help. Is there a test I can do to figure out if there exists a lock
on a record? Is an exception thrown when a lock exists and the
application does a SELECT FOR UPDATE (preferably in a non-DB-specific
way)?
Received on Tue Feb 25 2003 - 08:38:05 CST
