Re: Losing Connections - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: Losing Connections
Date
Msg-id 20040224153446.A622@bacon
Whole thread Raw
In response to Losing Connections  (Pablo Velasquez Rivas <pvelasquez@its.co.cr>)
List 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         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Losing Connections
Next
From: Tom Lane
Date:
Subject: Re: Losing Connections