From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: oliver@opencloud.com
To: tgl@sss.pgh.pa.us
Cc: pgsql-admin@postgresql.org
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] ERROR: canceling query due to user request
Date: Thu, 15 Sep 2005 09:22:58 -0500
Message-ID: <s3293d84.063@gwmta.wicourts.gov> (raw)
One more thought on the topic -- in the particular case where we hit
this, the Statement did not have any requests active on its connection.
If the driver can determine this, it could return from the cancel method
without doing anything.
-Kevin
>>> Oliver Jowett <oliver@opencloud.com> 09/13/05 6:00 PM >>>
Tom Lane wrote:
> This has been discussed before (try the pgsql-jdbc list archives).
> I believe we concluded that an appropriate fix was to not consider the
> cancel request "done" until the client sees the separate connection
> dropped by the postmaster. libpq's cancel functions wait for that to
> happen, and I thought that JDBC had been fixed as well --- maybe you are
> using an old driver version?
I thought this got done too, but looking at the current JDBC driver code
I don't see it..
-O
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, oliver@opencloud.com, tgl@sss.pgh.pa.us, pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] ERROR: canceling query due to user request
In-Reply-To: <s3293d84.063@gwmta.wicourts.gov>
References: <s3293d84.063@gwmta.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox