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

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
Cc: 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 09:41:07
Message-ID: 41402533.2080702@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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.

-O

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-09-09 10:42:42 Re: [JDBC] ERROR: canceling query due to user request
Previous Message Paul Thomas 2004-09-09 08:53:21 Re: [JDBC] ERROR: canceling query due to user request

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-09-09 10:42:42 Re: [JDBC] ERROR: canceling query due to user request
Previous Message Paul Thomas 2004-09-09 08:53:21 Re: [JDBC] ERROR: canceling query due to user request