Got it, thank you. The other way this can happen is if the application checks out a connection and then never returns it, and expects it to be used. For this you will want to enable
removeAbandonedTimeout="60" removeAbandoned="true" logAbandoned="true" this should tell you pretty quickly if you got a component that is hogging the connection. So test that first. Now if that is the case, there is a way to fix that: 1. remove the above settings 2. compile and configure the interceptor described in: https://issues.apache.org/bugzilla/show_bug.cgi?id=52024 In this interceptor, when a failure occurs, it automatically reconnects and retries the operation. And that is the only way to get around the problem (assuming my assumption is correct) Filip ----- Original Message ----- > From: "Colin Ingarfield" <colin...@gmail.com> > To: users@tomcat.apache.org > Sent: Wednesday, March 21, 2012 9:30:46 AM > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
