Re: Implementing setQueryTimeout() - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Implementing setQueryTimeout()
Date
Msg-id 17814.1203384054@sss.pgh.pa.us
Whole thread Raw
In response to Re: Implementing setQueryTimeout()  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Implementing setQueryTimeout()
List pgsql-jdbc
Oliver Jowett <oliver@opencloud.com> writes:
> I'd argue that "close connection on network timeout if setQueryTimeout()
> is set" is better than "do absolutely nothing special if
> setQueryTimeout() is set", anyway. If you don't want queries being
> aborted because they are taking too long to complete.. don't set a query
> timeout!

I think it's a serious, serious conceptual error to tie network timeouts
to query timeouts.  Maybe your specific application needs them to be the
same, but implementing something that forces them to be the same is a
good way to guarantee that your work won't be generally useful or
acceptable for the mainstream driver.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Jan de Visser
Date:
Subject: Re: Getting "This ResultSet is closed" exceptions
Next
From: Paul Tomblin
Date:
Subject: Re: Getting "This ResultSet is closed" exceptions