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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <oliver(at)opencloud(dot)com>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] ERROR: canceling query due to user request
Date: 2005-09-15 14:22:58
Message-ID: s3293d84.063@gwmta.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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(at)opencloud(dot)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

Browse pgsql-admin by date

  From Date Subject
Next Message Warren Snelling 2005-09-15 19:10:04 7.4 <-> 8.0
Previous Message Bradley Kieser 2005-09-15 10:18:41 Re: PSQL in a script

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-09-15 14:26:43 Re: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend
Previous Message Sven Hütten 2005-09-15 14:12:38 org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend