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

Re: Losing Connections

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Pablo Velasquez Rivas <pvelasquez(at)its(dot)co(dot)cr>
Cc: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Losing Connections
Date: 2004-02-24 15:34:46
Message-ID: 20040224153446.A622@bacon (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
On 24/02/2004 14:19 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??

The firewall sounds like the most likely source of the problem.

Paul Thomas
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         |   |

In response to

pgsql-jdbc by date

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

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