I added the 3 abandoned settings but I don't see any indication in the tomcat log that connections are being abandoned. I also made the max pool size pretty small.. my application would have failed quickly if all the connections we're being incorrectly held up.
Anything else I can try? Thanks again for your help. -- Colin On Wed, Mar 21, 2012 at 10:41 AM, Filip Hanik Mailing Lists < devli...@hanik.com> wrote: > 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 > >
