Add in validationQuery and testOnBorrow as seen below
Resource driverClassName=com.mysql.jdbc.Driver
logAbandoned=false
maxActive=35
maxIdle=2
maxWait=5000
name=jdbc/TheName
password=password
removeAbandoned=true
removeAbandonedTimeout=60
Hi all,
I have a problem with:
Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x
And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6
I configured the connection in tomcat like this:
Resource driverClassName=com.mysql.jdbc.Driver
logAbandoned=false
maxActive=35
maxIdle=2