Re: [JDBC] Support for JDBC setQueryTimeout, et al. - Mailing list pgsql-hackers

From Radosław Smogura
Subject Re: [JDBC] Support for JDBC setQueryTimeout, et al.
Date
Msg-id 88dcb3988805ede17af4a460ad251534@smogura-softworks.eu
Whole thread Raw
In response to Re: [JDBC] Support for JDBC setQueryTimeout, et al.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: [JDBC] Support for JDBC setQueryTimeout, et al.  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Mon, 11 Oct 2010 08:29:16 -0500, "Kevin Grittner"
<Kevin.Grittner@wicourts.gov> wrote:
> David Fetter <david@fetter.org> wrote:
>
>> Please find enclosed a WIP patch from one of my co-workers
>> intended to support JDBC's setQueryTimeout, along with the patch
>> for JDBC that uses it.
>
> I agree that it would be very nice to support this JDBC feature, but
> I'm not clear on why this can't be done with just JDBC changes using
> the java.util.Timer class and the existing Statement.cancel()
> method.  Can you explain why the backend needed to be touched?
>
> -Kevin

I sent such patch fully in Java
(http://archives.postgresql.org/pgsql-jdbc/2009-11/msg00010.php),
implementing cancellation with Timer and "cancel query" facility of PSQL
server, unfortunately none has revised it, even that setQuertyTimeout todo
is for long time on dashboard, and it's important for enterprise class
software.

----------
Radosław Smogura
http://www.softperience.eu

pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: pgxs docdir question
Next
From: Pavel Stehule
Date:
Subject: Re: wip: functions median and percentile