Re: After server restart I get - An I/O error occured while sending to the backend. - Mailing list pgsql-jdbc

From Lew
Subject Re: After server restart I get - An I/O error occured while sending to the backend.
Date
Msg-id ht9srs$7lh$1@news.albasani.net
Whole thread Raw
In response to Re: After server restart I get - An I/O error occured while sending to the backend.  (Daniele Depetrini <daniele.depetrini@criticalpath.net>)
List pgsql-jdbc
Daniele Depetrini wrote:
> I've written a wrapper that use[s] the "setTransationIsolation" method as
> first operation against a just[-]obtained connection to implicitly check
> if it is still alive.

And what if the connection dies just after you've set transaction isolation
but before you do anything else with it?

As Craig Ringer pointed out, that technique does not relieve following code of
the responsibility to check for exceptions due to a lost connection, so what
does it buy you but the performance hit of an extra round trip to the database?

--
Lew

pgsql-jdbc by date:

Previous
From: harryh
Date:
Subject: no timeout in AbstractJdbc23PoolingDataSource#getPooledConnection
Next
From: Lew
Date:
Subject: Re: Using java.lang.Character for "char" data type