tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Filip Hanik Mailing Lists <devli...@hanik.com>
Subject Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)
Date Wed, 21 Mar 2012 15:41:49 GMT
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" <colini98@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message