Re: How cancel query through JDBC?

Oh....it will be worth it. You'll love some of the new features which make administration easier!

Cheers,
Brian

Don Seiler wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"