an efficient way of checking if the connection to a db is actually open

Поиск
Список
Период
Сортировка
От Assad Jarrahian
Тема an efficient way of checking if the connection to a db is actually open
Дата
Msg-id 4bd3e1480512151247u50479082vd08b9a1563d54604@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: CallableStatements: index starts at 2
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: an efficient way of checking if the connection to a db