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
Список
Дерево обсуждения
an efficient way of checking if the connection to a db is actually open Assad Jarrahian <jarraa@gmail.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>
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 Tom Lane <tgl@sss.pgh.pa.us>
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 Tom Lane <tgl@sss.pgh.pa.us>
Re: an efficient way of checking if the connection to a db Kris Jurka <books@ejurka.com>
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()
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
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 по дате отправления