We are upgrading a legacy system from Sybase to Postgres. In one of the
modules, we wish, if an SQLException is caught, to close and reopen the
connection and retry - but only if the cause of the Exception is a dropped
connection. The original developer of the code implemented this by searching
for the substrings "Broken pipe" or "Connection already closed" in the
Is there a more elegant way to find out whether the connection has been
dropped from within the catch clause?
And if not, I assume the above substrings are no longer pertinent - what
messages in PostgreSQL indicate a dropped connection?
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2009-08-02 22:20:47|
|Subject: Re: How to retry when connection has been closed?|
|Previous:||From: Thomas Kellerer||Date: 2009-08-01 20:53:59|
|Subject: Datatype of domains not reported correctly.|