Re: Connection pooling problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Didrik Pinte <dp(at)adhoc(dot)be>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection pooling problems
Date: 2003-02-04 09:18:25
Message-ID: 12114.1044350305@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Didrik Pinte <dp(at)adhoc(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Didrik Pinte 2003-02-04 09:27:11 Re: Connection pooling problems
Previous Message Didrik Pinte 2003-02-04 08:37:35 Connection pooling problems