geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: Does the pool handle stale connections?
Date Tue, 29 Jul 2008 22:16:55 GMT
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.
>


Mime
View raw message