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 (com.ibm.as400.access.AS400JDBCDriver)
Pool Min Size: 0
Pool Max Size: 100
Blocking Timeout: 5000
Idle Timeout: 15

- David Frahm

From: David Jencks <david_jencks@yahoo.com>
To: user@geronimo.apache.org
Date: 07/29/2008 05:15 PM
Subject: 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  
> Nabble.com.