Thanks for the reply. Setting testOnBorrow to true is something I'll try but according to:
http://commons.apache.org/dbcp/configuration.html If testOnBorrow is set to true, the validation query must be set to a 'non-null string'. Presumably this means that the query must always return a value such as validationQuery = "select now()" always returning the date / time? validationQuery = "select now()" markt-2 wrote: > > MartinOShea wrote: >> But I think what is >> happening after eight hours of inactivity, is that the system is trying >> to >> reuse a connection pool object that MySQL has closed down after its >> default >> eight hour period. > > Sounds likely. > >> testOnBorrow = "false" > > Try setting this to true. > > Mark > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25679823.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
