Skip site navigation (1) Skip section navigation (2)

Re: Fastest way to check aliveness of connection

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Fastest way to check aliveness of connection
Date: 2008-02-26 22:20:24
Message-ID: 47C490A8.1090708@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Daniel Migowski wrote:
> Hello,
> 
> I want to implement a c3p0 ConnectionTester and now need a fast way to 
> check for the alivelyness of a Connection. Currently I issue a "select 
> 1" to the database and if I don't get an exception I assume the 
> connection is still alive.
> 
> Is there a faster way? How can I check if the underlying socket is still 
> alive without doing a JDBC request? This has to work only with 
> PostgreSQL JDBC, so I can cast to any postgres interface available.

Running an empty query ("") is probably the simplest way.

In theory you could do something slightly faster at the protocol level 
(just send Sync and wait for ReadyForQuery) but there's no interface 
currently exposed to do that and I doubt that it will be much faster 
than an empty query anyway.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: dmpDate: 2008-02-27 07:35:38
Subject: Array Char/VarChar Size
Previous:From: Daniel MigowskiDate: 2008-02-26 13:36:56
Subject: Fastest way to check aliveness of connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group