Detecting 'socket errors' - closing the Connection object

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: "pgsql-jdbc-list" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Detecting 'socket errors' - closing the Connection object
Date: 2003-07-21 17:38:42
Message-ID: 00c301c34fae$edf5ab30$3201a8c0@rasta
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have a connection pool that opens several connections and passes them out
to individual threads as needed. Normally this works just fine. However,
if the postgresql database is restarted, or if the database is on another
network segment, hiccups on the network will cause socket errors on the
underlying JDBC connection.

When a connection is returned to the pool, I'm calling the 'isClosed()'
method to see if the underlying connection has been closed, but apparently
when there is a socket error, the JDBC connection is not automatically being
closed, despite the fact that such an error will always be unrecoverable.

I've also seen the same problem occur on the Oracle JDBC drivers (oracle sql
exception errors 17002 and 17008).

Is there a reason why the JDBC implementations don't close the Connection
object when they get an I/O error on the socket? Or am I doing something
else wrong in trying to detect that the connection has failed and must be
closed and reopened before being used again?

Thanks,
David

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-07-21 17:51:41 Re: IN clauses via setObject(Collection) [Was: Re: Prepared
Previous Message Kim Ho 2003-07-21 17:23:21 Fix for receiving empty query errors.