On Thu, 19 Apr 2007, Adrian Custer wrote:
> i'm trying to make our app's connection to postgresql robust. In
> testing, I've noticed that if the network interfaces don't exist, the
> java instance locks up.
>
> 0.setup the server e.g. localhost:5432, user:auser, password:hello
>
> 1. Take down your network e.g. ifdown lo
>
> 2. run a simple connect to postgresql jdbc such as the file attached
>
> ==> the file hangs indefinitely.
>
> Does anyone have a suggestion for preventing this?
>
The PG driver does not respect DriverManager.getLoginTimeout, although I'm
not sure why. You can instead add the URL parameter ?loginTimeout=5 or
similar to get a timeout on failure to setup a connection.
Kris Jurka