an efficient way of checking if the connection to a db is actually open - Mailing list pgsql-jdbc

From Assad Jarrahian
Subject an efficient way of checking if the connection to a db is actually open
Date
Msg-id 4bd3e1480512151247u50479082vd08b9a1563d54604@mail.gmail.com
Whole thread Raw
Responses Re: an efficient way of checking if the connection to a db  (Kris Jurka <books@ejurka.com>)
Re: an efficient way of checking if the connection to a db is actually open  (Paul Thomas <paul@tmsl.demon.co.uk>)
Re: an efficient way of checking if the connection to a db is actually open  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-jdbc
Hi All,
   Trying to check if a connection is actually open every time I perform an operation (if not, I want to reopen it and perform that operation). isClosed()
is no good, as in, it only guarantees true if close() was actually called on it.

The documentation says, the only real way is to actually call an sql statement on it. That seems inefficient. Is there any other way that is recommended?
Much thanks in advance.

-assad

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: CallableStatements: index starts at 2
Next
From: Kris Jurka
Date:
Subject: Re: an efficient way of checking if the connection to a db