Re: connection timeout? - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: connection timeout?
Date
Msg-id 41B0D1B0.6040701@opencloud.com
Whole thread Raw
In response to connection timeout?  (Antonini Roberto <Roberto.Antonini@TILAB.COM>)
List pgsql-jdbc
Antonini Roberto wrote:

>     * I disconnected network cable between PC and DB server

> The application remains blocked on
>             DriverManager::getConnection

I'd expect this to eventually time out, but it might take several
minutes. It depends on your TCP stack.

> Is it a timeout issue?

Yes.

> If so, how can I set this timeout?

Currently you can't, mostly because it hasn't been a big enough issue
for anyone to step forward and implement.

When implemented I'd expect it would be set via a URL parameter.

The Java socket primitives makes it quite hard to do timeouts on connect
anyway. Either you have to use NIO (doesn't exist until 1.4, would be an
invasive change) or Socket.connect() (doesn't exist until 1.4). So
you're out of luck under 1.3, and the driver will have to do conditional
compilation to use 1.4-specific code as it needs to build under 1.3.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Bug in setFetchSize
Next
From: "Chris White (cjwhite)"
Date:
Subject: Use of bytea