Re: Improvements for statement cancellation - Mailing list pgsql-jdbc

From Florent Guillaume
Subject Re: Improvements for statement cancellation
Date
Msg-id CAF-4BpOwL=Oz_mG=auSoEcuDRVoAJNXOMH+8i2oFORJEMs5cJg@mail.gmail.com
Whole thread Raw
In response to Re: Improvements for statement cancellation  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-jdbc
On Fri, Apr 12, 2013 at 4:32 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> Pawel Veselov <pawel.veselov@gmail.com> wrote:
>> I'm wondering if it's possible if Postgres JDBC could change the
>> implementation of cancel() so that cancelQuery() is only sent if
>> the statement being called is the actual statement that is being
>> executed on the connection, and otherwise be a no-op.
>
> I wondered the same thing back in 2005:
> http://www.postgresql.org/message-id/438F2DE5.EE98.0025.0@wicourts.gov
> I still think that something of the sort would be a good idea.

Agreed, the current Statement.cancel() behavior can only be described as buggy.

Florent

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87


pgsql-jdbc by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Improvements for statement cancellation
Next
From: Nicholas White
Date:
Subject: Re: Patch: Force Primitives