Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How cancel query through JDBC?
Something to think about for the future perhaps. Unfortunately I'm
currently on Oracle 7.3.4.5. I'm in charge of upgrading to Oracle 9i by
the end of the year, which isn't going to be fun but hopefully will be
worth it.
Thanks anyway.
Don.
On Thu, 31 Jul 2003 17:04:18 +0000, Brian Peasland wrote:
> An easy way in Oracle 9i is to use the new FOR UPDATE WAIT clause. You
> can specify the timeout isnstead of waiting forever. JDBC probably won't
> handle this feature for you, but you can place the update logic in a
> stored proc and have your Java program call the stored proc.
>
> HTH,
> Brian
Received on Thu Jul 31 2003 - 12:30:18 CDT