Re: Losing Connections

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