Cancel JDBC Statement?

From: Bill Buchan <bill.buchan_at_ossian.net>
Date: Mon, 1 Nov 1999 18:30:08 -0000
Message-ID: <7vkm6d$m6$1@phys-ma.sol.co.uk>

I'm trying to cancel a long running query using the JDBC statement class cancel() method. Sometimes it works, sometimes it just hangs. It tends to be okay once the other thread has reached the point of fetching data, and fail if it hasn't.

Does anybody have any help they could offer on this? - On a quick search through Deja News I noticed a few people saying that there is a problem with the underlying OCI call. Is this true? Surely there must be some way to get this to work - reliably cancelling a query seems kind of important!

Any advice gratefully received,

Thanks,
- Bill. Received on Mon Nov 01 1999 - 12:30:08 CST