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.
