Re: Configure Oracle IDBC to not wait for locks
Date: Wed, 29 Nov 2000 21:59:12 -0800
Message-ID: <U1mV5.1152$Gj6.31212_at_nntp2.onemain.com>
[Quoted] I think you mean for update. Readers don't wait for writers in Oracle.
Jim
[Quoted] "Mark E. Hansen" <meh_at_NOSPAMunify.com> wrote in message
news:3A2585C5.FE2E976_at_NOSPAMunify.com...
>
> I would like to configure my ODBC application to not block when
> attempting to access rows in the Oracle database that have conflicting
> locks.
>
> In an OCI application, I make a call to "oopt" to set two options on
> the cursor: ROW_RLBACK and DONOT_WAIT (these get or'ed together). This
> causes the operation to return immediately with an error if a lock
> conflict is encountered.
>
> However, I can't find any way to do this from my ODBC application.
> Can anyone tell me how to accomplish this?
>
> Regards,
Received on Thu Nov 30 2000 - 06:59:12 CET