Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Fastest way to ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 1893 of 1987
Post > Topic >>

Fastest way to check aliveness of connection

by dmigowski@[EMAIL PROTECTED] (Daniel Migowski) Feb 26, 2008 at 02:36 PM

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.

With best regards,
Daniel Migowski

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@[EMAIL PROTECTED]
 so that your
       message can get through to the mailing list cleanly
 




 3 Posts in Topic:
Fastest way to check aliveness of connection
dmigowski@[EMAIL PROTECTE  2008-02-26 14:36:56 
Re: Fastest way to check aliveness of connection
oliver@[EMAIL PROTECTED]   2008-02-27 11:20:24 
Re: Fastest way to check aliveness of connection
dmigowski@[EMAIL PROTECTE  2008-02-27 08:57:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 23:52:09 CDT 2008.