Re: Losing Connections

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 |
+------------------------------+---------------------------------------------+