You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by me...@assetmanagement.natexis.fr on 2003/11/06 14:11:14 UTC
dbcp size nightmare
hi all,
I have configured my dbcp connection pool like the fragment
below.
<Resource name="jdbc/recProduit" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/recProduit">
<parameter><name>username</name><value>mailer</value></parameter>
<parameter><name>password</name><value>mail2002</value></parameter>
<parameter><name>maxActive</name><value>3</value></parameter>
<parameter><name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail</value></parameter>
</ResourceParams>
I don't know why, but the pool size is always increasing.
I've tried the maxActive parameter unsucessfully.
I've search the list before posting this question.
But I've found no cure to my problem.
Any help to detect what's missing in my config would
be greetly appreciated.
Meissa
Meissa Sakho
NATEXIS ASSET MANAGEMENT
Direction de l'organisation
Tel. : 01 58 19 45 71
http://www.assetmanagement.natexis.fr
L'integrite de ce message n'etant pas assuree sur internet, Natexis
Banques Populaires ne peut etre tenu responsable de
son contenu. Toute utilisation ou diffusion non autorisee est
interdite. Si vous n'etes pas destinataire de ce message, merci de le
detruire et d'avertir l'expediteur.
The integrity of this message cannot be guaranteed
on the Internet. Natexis Banques Populaires can not therefore be
considered responsible for the contents.Any unauthorized use or dissemination is prohibited.
If you are not the intended recipient of this message, then please delete it and
notify the sender.
Re: dbcp size nightmare
Posted by Dirk Verbeeck <di...@pandora.be>.
Are you using v1.1 ?
If you are then make sure you remove all v1.0 jars of Commons-DBCP and
Commons-Pool. Version 1.1 of DBCP is only sopported with v1.1 of Pool.
-- Dirk
meissa.Sakho@assetmanagement.natexis.fr wrote:
> hi all,
>
> I have configured my dbcp connection pool like the fragment
> below.
>
> <Resource name="jdbc/recProduit" auth="Container"
> type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/recProduit">
> <parameter><name>username</name><value>mailer</value></parameter>
> <parameter><name>password</name><value>mail2002</value></parameter>
> <parameter><name>maxActive</name><value>3</value></parameter>
> <parameter><name>driverClassName</name>
> <value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
> <parameter><name>url</name>
>
> <value>jdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail</value></parameter>
>
> </ResourceParams>
>
>
> I don't know why, but the pool size is always increasing.
>
>
>
> I've tried the maxActive parameter unsucessfully.
>
> I've search the list before posting this question.
> But I've found no cure to my problem.
>
> Any help to detect what's missing in my config would
> be greetly appreciated.
>
> Meissa
>
> Meissa Sakho
> NATEXIS ASSET MANAGEMENT
> Direction de l'organisation
> Tel. : 01 58 19 45 71
> http://www.assetmanagement.natexis.fr
>
>
> L'integrite de ce message n'etant pas assuree sur internet, Natexis
> Banques Populaires ne peut etre tenu responsable de
> son contenu. Toute utilisation ou diffusion non autorisee est
> interdite. Si vous n'etes pas destinataire de ce message, merci de le
> detruire et d'avertir l'expediteur.
>
> The integrity of this message cannot be guaranteed
> on the Internet. Natexis Banques Populaires can not therefore be
> considered responsible for the contents.Any unauthorized use or dissemination is prohibited.
> If you are not the intended recipient of this message, then please delete it and
> notify the sender.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
RE: dbcp size nightmare
Posted by Michael Holly <MH...@talisentech.com>.
Make sure you are closing all your resources after running the SQL.
Connection, Statement, ResultSet.
Michael Holly
"Developing Software from requirements and Walking on water, both are
easy when frozen."
"Good, Fast, and Cheap... pick Two"
-----Original Message-----
From: meissa.Sakho@assetmanagement.natexis.fr
[mailto:meissa.Sakho@assetmanagement.natexis.fr]
Sent: Thursday, November 06, 2003 7:11 AM
To: commons-user@jakarta.apache.org
Subject: dbcp size nightmare
hi all,
I have configured my dbcp connection pool like the fragment below.
<Resource name="jdbc/recProduit" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/recProduit">
<parameter><name>username</name><value>mailer</value></parameter>
<parameter><name>password</name><value>mail2002</value></parameter>
<parameter><name>maxActive</name><value>3</value></parameter>
<parameter><name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail</value></param
eter>
</ResourceParams>
I don't know why, but the pool size is always increasing.
I've tried the maxActive parameter unsucessfully.
I've search the list before posting this question.
But I've found no cure to my problem.
Any help to detect what's missing in my config would
be greetly appreciated.
Meissa
Meissa Sakho
NATEXIS ASSET MANAGEMENT
Direction de l'organisation
Tel. : 01 58 19 45 71
http://www.assetmanagement.natexis.fr
L'integrite de ce message n'etant pas assuree sur internet, Natexis
Banques Populaires ne peut etre tenu responsable de son contenu. Toute
utilisation ou diffusion non autorisee est interdite. Si vous n'etes pas
destinataire de ce message, merci de le detruire et d'avertir
l'expediteur.
The integrity of this message cannot be guaranteed
on the Internet. Natexis Banques Populaires can not therefore be
considered responsible for the contents.Any unauthorized use or
dissemination is prohibited. If you are not the intended recipient of
this message, then please delete it and
notify the sender.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org