Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT for UPDATE in web application
What driver are you using? I tested with ORACLE JDBC thin driver and
received
ORA-00054 error if "NOWAIT" clause is specified, which is expected
behavior. Can you post your code?
biffmalone_at_hotmail.com (Biff Malone) wrote in message news:<f2efd06c.0302250638.13c27e3d_at_posting.google.com>...
> 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 - 14:53:43 CST