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

Reply via email to