commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pramodh Peddi" <ppe...@IMPRIVATA.com>
Subject RE: [DBCP] removeAbandoned and removeAbandonedTimeout feature
Date Wed, 13 Jul 2005 20:29:10 GMT
Hi Dirk/All,

 

A friendly reminder about the problems I am facing when using
commons-dbcp-1.2.jar. This is what happened so far in order:

I sent the junit test.

You tested the junit and said you are unable to reproduce the problem
(but, I can reproduce the problem with the same junit test).

You asked me the version of the library I am using.

I said I am using version 1.2.

 

I am still facing the two problems, first one being very severe, and the
second being a 'nice to have' thing.

 

I can list the problems again:

1. When using *abandon* settings, to close any dangling active
connections, it is not really closing the active connections after the
configured period of time. These are my settings: 

factory = org.apache.commons.dbcp.BasicDataSourceFactory

username = myuser

password = mypassword

driverClassName = com.mysql.jdbc.Driver

url =
jdbc:mysql://localhost:3306/IMPRIVATA?autoReconnect=true&useServerPrepSt
mts=true&jdbcCompliantTruncation=false

maxActive = 15

maxWait = 360000

removeAbandonedTimeout = 1800000

removeAbandoned = true

logAbandoned = true

poolPreparedStatements = true

(Note: I tested with removeAbandonedTimeout = 60000, which is 1 minute
and it did not work)

 

2. When I specify the initialSize to be 12, datasource.getNumActive()
returns 12, which means there are 12 active connections lying around.
And I verified that these 12 connections are really active.

 

Thanks,

 

Pramodh.

 

-----Original Message-----
From: Pramodh Peddi 
Sent: Thursday, June 30, 2005 10:05 AM
To: Jakarta Commons Users List
Subject: RE: [DBCP] removeAbandoned and removeAbandonedTimeout feature

 

I am using commons-dbcp-1.2. I used to use version 1.1 before, which did

not support initialSize parameter and that's one of the main reasons I

moved to version 1.2. And now that I think, wondering if shifting to 1.2

made *abandoned* stopped it from working (please note that *abandoned*

thing not working is one of the two problems I am encountering, along

with initialSize thing) as it REALLY worked before.

 

 

 

Pramodh.

 

 

 

-----Original Message-----

From: Dirk Verbeeck [mailto:dirk.verbeeck@pandora.be] 

Sent: Thursday, June 30, 2005 2:07 AM

To: Jakarta Commons Users List

Subject: Re: [DBCP] removeAbandoned and removeAbandonedTimeout feature

 

 

 

Hi Pramodh,

 

 

 

Received, compiled and ran the test. But can't reproduce your problem.

 

What version of the DBCP/pool libraries are you using?

 

 

 

-- Dirk

 

 

 

Pramodh Peddi wrote:

 

> Hey Dirk,

 

> 

 

> Just want to let you know that yesterday I sent you the junit test

just

 

> to your email @ dirk.verbeeck@pandora.be. Hope you received it. Let me

 

> know if you have not received it or if you can't run the junit test. 

 

> 

 

>  

 

> 

 

> Thanks for the help.

 

> 

 

>  

 

> 

 

> Pramodh.

 

 

 

 

 

---------------------------------------------------------------------

 

To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org

 

For additional commands, e-mail: commons-user-help@jakarta.apache.org

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message