My configuration:
<Resource auth="Container"
name="jdbc/cdb.mysql"
defaultAutoCommit="false"
driverClassName="com.mysql.jdbc.Driver"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
url="jdbc:mysql://XXXXX.com/XXXX_dev?sessionVariables=TRANSACTION
ISOLATION LEVEL READ COMMITTED"
username="XXXXX"
password="XXXXX"
maxActive="100"
maxIdle="100"
minIdle="10"
initialSize="10"
maxWait="10000"
testOnBorrow="true"
type="javax.sql.DataSource"
validationQuery="SELECT 1"/>
I have testOnBorrow and validationQuery set as you suggest, so I do not
think that is the issue.
Thanks,
Colin