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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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