Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Date
Msg-id Pine.BSO.4.64.0708101218210.14101@leary.csoft.net
Whole thread Raw
In response to Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc

On Fri, 10 Aug 2007, Tom Lane wrote:

> Kris Jurka <books@ejurka.com> writes:
>> People want the query to be stopped, but they don't want their whole
>> connection to be killed which is what your change does.
>
> Can't you just "set statement_timeout = something" if you don't want to
> let long queries complete?
>

Unfortunately the timeout is set on a Statement object, not the
Connection, so any number of different timeouts may be floating around and
we'd need to set and reset the timeout on each query execution to ensure
we're executing with the right timeout.  So that's how it will be
implemented eventually, but it's not just a trivial SET that we're
missing.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Next
From: Andrea Spinelli
Date:
Subject: Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter