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

From Till Toenges
Subject Re: Implementing setQueryTimeout() - round 2
Date
Msg-id 47BA92F1.3040707@kyon.de
Whole thread Raw
In response to Re: Implementing setQueryTimeout() - round 2  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Implementing setQueryTimeout() - round 2  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:
> - softQueryTimeout: 0=disabled, >0 = timeout in ms, default 0
> - hardQueryTimeout: 0=disabled, >0 = timeout in ms, default 0
> - softQueryMargin: -1=disabled, >=0 = margin in ms, default 0
> - hardQueryMargin: -1=disabled, >=0 = margin in ms, default 60s

I had to think about how you mean this. Doesn't this reduce to just one
useful parameter, namely hardQueryMargin? If hardQueryMargin is set,
then kill the connection after setQueryTimeout() + hardQueryMargin
seconds? All other cases would be covered by setting appropriate values
for these two.

And i'm still not quite convinced that anything but "softQueryTimeout"
should be implemented by the driver, but that's just my personal
opinion. How about starting with the simple case (using set), and then
see how it turns out in the real world?


Till

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Implementing setQueryTimeout()
Next
From: Oliver Jowett
Date:
Subject: Re: Implementing setQueryTimeout() - round 2