On 23/05/10 06:48, Daniele Depetrini wrote:
> I've written a wrapper that use the "setTransationIsolation" method as
> first operation against a just obtained connection to implicitly check
> if it is still alive.
Yep, or you can SHOW a variable if you like. That won't mess with
ongoing transaction state, won't create a snapshot (like SELECT 1;
might), etc.
Again, though, remember that you still need to be prepared to handle
connections dying while you're in the middle of doing work.
--
Craig Ringer