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 <[EMAIL PROTECTED]> To: [email protected] 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... thanks 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: http://www.nabble.com/Does-the-pool-handle-stale-connections--tp18718712s134p18718712.html > Sent from the Apache Geronimo - Users mailing list archive at > Nabble.com. >
