Re: [JDBC] ERROR: canceling query due to user request

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, Tore Halset <halset(at)pvv(dot)ntnu(dot)no>, pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] ERROR: canceling query due to user request
Date: 2004-09-09 16:02:14
Message-ID: 6355.1094745734@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> writes:
> On 09/09/2004 10:41 Oliver Jowett wrote:
>> 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?

IIRC there was such a bug at one time, but I thought it had been fixed.
Maybe the problem is use of an old driver?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-09-09 16:07:45 Re: How to determine a database is intact?
Previous Message David Garamond 2004-09-09 15:33:11 Re: Text Search vs MYSQL vs Lucene

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-09-09 21:04:06 Re: [JDBC] ERROR: canceling query due to user request
Previous Message Pierre-Frédéric Caillaud 2004-09-09 12:56:35 Byte Sizes