Re: Driver.connect Timeout - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Driver.connect Timeout
Date
Msg-id Pine.LNX.4.33.0401301948150.25251-100000@leary.csoft.net
Whole thread Raw
In response to Re: Driver.connect Timeout  (Jeff Kolesky <jeff@edusoft.com>)
Responses Re: Driver.connect Timeout
List pgsql-jdbc

On Fri, 30 Jan 2004, Jeff Kolesky wrote:

> As it turns out, I have been working on a solution that will allow
> you to do just what you want.  My company has been running into a
> problem when a database goes down, that the Driver hangs when trying
> to create a connection.  In response, I added in a way to set the
> socket timeout during connection creation.

Could you be more specific about the problem that this solves?  I was
under the impression that the call that really needed to be changed was
connection = new Socket(host,post) in the PGStream constructor because a
dns or other network error could make this take a long time before timing
out.  Without testing it, your patch looks like it only is useful in the
case where a connection has been established, but hasn't gone through the
authentication process and the database crashed in that split second.

Kris Jurka



pgsql-jdbc by date:

Previous
From: Jeff Kolesky
Date:
Subject: Re: Driver.connect Timeout
Next
From: Jeff Kolesky
Date:
Subject: Re: Driver.connect Timeout