Re: [JDBC] ERROR: canceling query due to user request - Mailing list pgsql-general

From Paul Thomas
Subject Re: [JDBC] ERROR: canceling query due to user request
Date
Msg-id 20040909114242.A1057@bacon
Whole thread Raw
In response to Re: [JDBC] ERROR: canceling query due to user request  (Oliver Jowett <oliver@opencloud.com>)
Responses Byte Sizes  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Re: [JDBC] ERROR: canceling query due to user request  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 09/09/2004 10:41 Oliver Jowett wrote:
> Paul Thomas wrote:
>
>> Given that statement.cancel() should only be used to cancel a running
>> query, I think the problem is more in your framework's misuse of
>> cancel() rather than in the driver itself.
>
> JDBC gives you no way to ensure you only call cancel() on a running query
> (there's a race between query execution returning and the call to
> cancel()). Calling cancel() on a statement that's not currently executing
> should do nothing; if it ends up cancelling a future query, it's a driver
> bug.

Thanks for the explaination Oliver. Maybe there is a driver bug then?

--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+

pgsql-general by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [JDBC] ERROR: canceling query due to user request
Next
From: Christopher Browne
Date:
Subject: Re: Migrating from MaxDB to postgresql