commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyson Lowery <>
Subject Re: DBCP - unclosed connections
Date Fri, 12 Nov 2010 17:15:28 GMT
Thanks for the help.  Unfortunately, I've made the change to upgrade and 
I'm still seeing the issue.  I've gone ahead and added some more 
debugging info to my code.   I'm seeing the issue about 1% of the time 
with this test case.  I'm outputting debugging information before my try 
block, and at the end of my finally block (among other places).  A grep 
count shows that there are an equal number of these statements in the 
catalina.out file over a specific time period, 637.  I am checked how 
many times this page appeared in the access_log over the same time 
period, and it also added up to 637.  During this time, it was reported 
that 6 connections were not closed by this jsp.  I also am outputting 
the result of Connection.isClosed() and Statement.isClosed() to 
catalina.out after I close the connections and statements.  These always 
show as true.

Please note that I have other jsps that I know are NOT closing 
connections properly.  Is it possible that has a bug 
and is reporting the wrong jsp page in the log?

Where should I dig next?


On 11/11/2010 1:08 PM, Mark Thomas wrote:
> On 11/11/2010 18:57, Tyson Lowery wrote:
>> Thanks Mark for taking the time to reply.
>> I've upgraded Tomcat to 6.0.29.  Do I still need to explicitly set the
>> factory to make sure I'm using DBCP 1.3?
> Maybe. 6.0.29 ships with DBCP 1.3 and Pool 1.5.4. To get the benefits of
> Pool 1.5.5 you'd need to follow the instructions below.
> 6.0.30 will include Pool 1.5.5
> Mark
>> On 11/11/2010 12:37 AM, Mark Thomas wrote:
>>> On 11/11/2010 05:11, Phil Steitz wrote:
>>>> I will check or someone else can confirm DBCP and pool versions.
>>> DBCP 1.2.2
>>> Pool 1.5.4
>>>>    If not the latest you can upgrade them independently of Tomcat and
>>>> you should try that.  See the Tomcat datasource docs for instructions
>>>> on how to do this.  Ask here or on tomcat-user if you need help.
>>> 1. Add latest DBCP&  Pool JARs to CATALINA_BASE/lib
>>> 2. Modify your Resource to include:
>>> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>>> 3. Restart
>>> Mark
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message