Re: Connection pooling problems - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Connection pooling problems
Date
Msg-id 12114.1044350305@sss.pgh.pa.us
Whole thread Raw
In response to Connection pooling problems  (Didrik Pinte <dp@adhoc.be>)
Responses Re: Connection pooling problems
List pgsql-jdbc
Didrik Pinte <dp@adhoc.be> writes:
> I'm currently running a Tomcat 4.0.6 using a pooled data source as a JNDI
> ressource (using the jakarta commons DBCP). The database is a PostgreSQL
> 7.3. The two computers are separated by a firewall. Everything works fine
> except a strange problem I can't solve.
> After a day on (it is not very regular), the application can't connect
> anymore to the database, i'm getting the following error in the Tomcat's log:

Is it possible that the application does nothing with the database for
an hour or so before the connection is lost?  If there's no traffic for
awhile, it could be that the firewall is dropping the connection.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Didrik Pinte
Date:
Subject: Connection pooling problems
Next
From: Didrik Pinte
Date:
Subject: Re: Connection pooling problems