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

Re: Losing Connections

From: Nicolas Modrzyk <Nicolas(dot)Modrzyk(at)inrialpes(dot)fr>
To: Pablo Velasquez Rivas <pvelasquez(at)its(dot)co(dot)cr>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>,"'c-jdbc(at)objectweb(dot)org'" <c-jdbc(at)objectweb(dot)org>
Subject: Re: Losing Connections
Date: 2004-02-24 15:06:20
Message-ID: 403B686C.5050507@inrialpes.fr (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Pablo,

If you use a C-JDBC driver on top of the Postgresql driver it checks for 
dropped connection using test statements when a request has failed.
You can see more there:
http://c-jdbc.objectweb.org/current/doc/userGuide/html/userGuide.html#dtd_databasebackend

Hope this can help you.

Nicolas Modrzyk,

Pablo Velasquez Rivas wrote:

> Hi.
>
> I have an application using psql 7.3.3 and pg73b1jdbc3.jar for 
> connections with PostgreSQL.
>
> When an user is idle for a while (like an hour) and then try to insert 
> or update something in the database, the user gets an error message. I 
> don't have right now the message, but it is something with the 
> connection with the database.
>
> I already asked at the postgresql forum, but the say that pgsql does 
> not drop connections. So, my question is if the jdbc driver for some 
> reason drop the connections.
>
> Or maybe  a firewall  is dropping the connections.
>
> Does anybody know what could be the problem??
>
> Thanks for any help.
>
>  
> ==                                 ==
>    Pablo A. Velasquez Rivas
> Computer Science Engineer
> ==                                 ==



In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2004-02-24 15:16:55
Subject: Re: Losing Connections
Previous:From: Pablo Velasquez RivasDate: 2004-02-24 14:19:36
Subject: Losing Connections

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