Re: Connection pooling problems

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