Re: [JDBC] Support for JDBC setQueryTimeout, et al.

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: "David Fetter" <david@fetter.org>, "PG Hackers" <pgsql-hackers@postgresql.org>, "PostgreSQL JDBC List" <pgsql-jdbc@postgresql.org>
Date: 2010-10-11T14:17:24Z
Lists: pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> 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?

... and, if you are seriously expecting to have that happen, why the
patch was submitted to pgsql-jdbc not pgsql-hackers?  I hadn't even
read it because I assumed it was strictly a JDBC change.

			regards, tom lane