Re: an efficient way of checking if the connection to a db is actually open

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Assad Jarrahian <jarraa(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: an efficient way of checking if the connection to a db is actually open
Date: 2005-12-16 07:57:38
Message-ID: 87wti58oel.fsf@meuh.mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Assad Jarrahian <jarraa 'at' gmail.com> writes:

> 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).

Why not performing the operation anyway, and when it fails
reopening the connection and retrying the operation?

Seems that it's the idea the JDBC designers had in mind, which
doesn't seem too stupid.

--
Guillaume Cottenceau

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message shrenik vikam 2005-12-16 08:50:49 problem of network is unreachable
Previous Message Kris Jurka 2005-12-15 23:36:53 Re: an efficient way of checking if the connection to a db