[EMAIL PROTECTED] wrote:
I'm currently using the version which is shipped with tomcat 4.18 distrib
I'm correctly closing all of my ressouces(connection,resulsets and
statement)
I'm still having the problem.
Meissa Sakho NATEXIS ASSET MANAGEMENT Direction de l'organisation Tel. : 01 58 19 45 71 http://www.assetmanagement.natexis.fr
Phillip Qin <[EMAIL PROTECTED]> 06/11/2003 16:51 Veuillez r�pondre � "Tomcat Users List"
Pour : "'Tomcat Users List'" <[EMAIL PROTECTED]> cc :
Objet : RE: R�f. : RE: dbcp pool size
Noop. Below is my config in context.xml. Try to use dbcp and pool version 1.1
<Resource name="jdbc/abcd" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/abcd"> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@your.com:1521:SID</value> </parameter> <parameter> <name>username</name> <value>username</value> </parameter> <parameter> <name>password</name> <value>password</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>minIdle</name> <value>10</value> </parameter> <parameter> <name>maxWait</name> <value>15000</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter>
<parameter> <name>validationQuery</name> <value>SELECT SYSDATE FROM DUAL</value> </parameter> <parameter> <name>testOnBorrow</name> <value>true</value> </parameter> <parameter> <name>minEvictableIdleTimeMillis</name> <value>-1</value> </parameter> <!-- sleeps 5 minutes --> <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>300000</value> </parameter> <parameter> <name>numTestsPerEvictionRun</name> <value>1</value> </parameter> <parameter> <name>testWhileIdle</name> <value>true</value> </parameter>
</ResourceParams>
-----Original Message----- From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: November 6, 2003 10:21 AM To: Tomcat Users List Subject: RE: R�f. : RE: dbcp pool size
Howdy, Yup.
Yoav Shapira Millennium ChemInformatics
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 10:20 AM To: Tomcat Users List Subject: R�f. : RE: dbcp pool size
Do you think a factory name is mandatory?
Meissa Sakho NATEXIS ASSET MANAGEMENT Direction de l'organisation Tel. : 01 58 19 45 71 http://www.assetmanagement.natexis.fr
"Shapira, Yoav" <[EMAIL PROTECTED]> 06/11/2003 14:56 Veuillez r�pondre � "Tomcat Users List"
Pour : "Tomcat Users List" <[EMAIL PROTECTED]> cc :
Objet : RE: dbcp pool size
Howdy, Perhaps a factory class name in your resource params? ;)
Yoav Shapira Millennium ChemInformatics
<parameter><name>maxActive</name><value>3</value></parameter>-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:12 AM To: [EMAIL PROTECTED] Subject: dbcp pool size
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>driverClassName</name><value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
<parameter><name>url</name>mete
<value>jdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail</value></para
r>delete
</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
it and
notify the sender.
This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential,
proprietary and/or privileged. This e-mail is intended only for the
individual(s) to whom it is addressed, and may not be saved, copied,
printed, disclosed or used by anyone else. If you are not the(an)
intended recipient, please immediately delete this e-mail from your
computer system and notify the sender. Thank you.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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.
This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential,
proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
