Can I check if a db connection is working?

From: "Jacob Vennervald Madsen" <jvm(at)gopinocchio(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Can I check if a db connection is working?
Date: 2002-08-06 15:10:03
Message-ID: AA6075F044E39D4DBBA876CA427A0E02057BED@gop-server.GOP-server.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi List

I have a database handler with a persistent connection to a Postgres database.
The problem is that if the TCP/IP connection between the database and the application is temporaryly down then I have to restart my application afterwards to reestablish the connection. This happens for example when the database is restarted with mode fast.
Is there any way to check if the database connection is working before using it?

Best regards,
Jacob Vennervald Madsen
Systems Developer

GoPinocchio
Norrebrogade 45
DK-2200 Copenhagen
www.gopinocchio.com
+45 26750106

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Legato 2002-08-06 15:46:42 Connecting via SSL not working (except from psql)
Previous Message James Kelty 2002-08-05 23:16:35 Re: Referential integrity error