geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: Does the pool handle stale connections?
Date Wed, 30 Jul 2008 13:13:08 GMT
I have frequent trouble with my database pool to an AS/400.  The database 
is taken down every night for backup, and at least once a week the 
connection pool is unusable after the database comes back up.  Restarting 
the connection pool makes everything work again.

We are new to Geronimo -- just this one app on one server -- so I don't 
have anything to compare to.  However, we have had this same issue with a 
couple 1.x versions before we upgraded to v2.

I had planned to do more troubleshooting before posting this, but since 
its already a topic I thought I'd go ahead.  It easily could be a 
configuration issue, although there are several WebSphere apps that do not 
have this trouble.

Configuration Info
Driver: JTOpen v6.1 (
Pool Min Size: 0
Pool Max Size: 100
Blocking Timeout: 5000
Idle Timeout: 15

- David Frahm

David Jencks <>
07/29/2008 05:15 PM
Re: Does the pool handle stale connections?

There's an idleTimeoutMinutes configuration setting on the connection 
manager with a default value of 15 (minutes).  Can you check that this 
is not reset to something longer than 8 hours?  Maybe the timeout is 
not working...

david jencks

On Jul 29, 2008, at 11:39 AM, swisst wrote:

> I can't seem to find the answer to this anywhere.  MySQL times out
> connections after 8 hours of inactivity.  Resulting in the common Q/A:
>  "I have a servlet/application that works fine for a day, and then 
> stops
>  working overnight".
>  Resolution:
>  MySQL closes connections after 8 hours of inactivity. You either
>  need to use a connection pool that handles stale connections or use
>  the "autoReconnect" parameter (see "USAGE AND INSTALLATION"). [...]
> Since the MySQL autoReconnect feature is on it's way out (being 
> deprecated),
> how do I configure my connection pool in Geronimo to recover from 
> stale
> connections?
> Thanks!
> -- 
> View this message in context:

> Sent from the Apache Geronimo - Users mailing list archive at 

View raw message