Postgres Pro
Downloads
Home   >   mailing lists

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

From Paul Thomas
Subject Re: an efficient way of checking if the connection to a db is actually open
Date
Msg-id 20051215213811.E5278@bacon
Whole thread Raw
In response to an efficient way of checking if the connection to a db is actually open  (Assad Jarrahian <jarraa@gmail.com>)
List pgsql-jdbc
Tree view 
On 15/12/2005 20:47 Assad Jarrahian wrote:
> 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?

Something like SELECT now() would be quick as doesn't involve any database
access.

--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+

pgsql-jdbc by date:

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