On Thu, 10 Apr 2008, Toru SHIMOGAKI wrote:
>
> Art Gramlich wrote:
>> Several jdbc drivers have recently added a way to set the SOTimeout on the
>> connections socket. For those of us accessing databases over a unreliable
>> connections, this can be quite helpful.
>
> Good. Although I submitted setKeepAlive patch to solve network down two month
> ago[1], it is not accepted so far. I think socket timeout is reasonable
> solution and easy to use.
>
It seems like keepalives are a better solution to dead server
detection. Don't timeouts just cause problems when you have a long
running query?
Kris Jurka