tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kwok Peng Tuck <pengt...@makmal.net>
Subject Re: Réf. : RE: Réf. : RE: dbcp pool size
Date Fri, 07 Nov 2003 08:05:17 GMT
Hello, meissa, please have a look at the email I sent to the commons-list.

meissa.Sakho@assetmanagement.natexis.fr 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 <Phillip.Qin@shareowner.com>
>06/11/2003 16:51
>Veuillez répondre à "Tomcat Users List"
>
>
>
>        Pour :  "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
>        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:Yoav.Shapira@mpi.com]
>
>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: meissa.Sakho@assetmanagement.natexis.fr
>>[mailto:meissa.Sakho@assetmanagement.natexis.fr]
>>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" <Yoav.Shapira@mpi.com>
>>06/11/2003 14:56
>>Veuillez répondre à "Tomcat Users List"
>>
>>
>>
>>       Pour :  "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>       cc :
>>
>>       Objet : RE: dbcp pool size
>>
>>
>>
>>Howdy,
>>Perhaps a factory class name in your resource params? ;)
>>
>>Yoav Shapira
>>Millennium ChemInformatics
>>
>>
>>    
>>
>>>-----Original Message-----
>>>From: meissa.Sakho@assetmanagement.natexis.fr
>>>[mailto:meissa.Sakho@assetmanagement.natexis.fr]
>>>Sent: Thursday, November 06, 2003 8:12 AM
>>>To: tomcat-user@jakarta.apache.org
>>>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>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></para
>>>      
>>>
>>mete
>>    
>>
>>>r>
>>>
>>>         </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.
>>>      
>>>
>>
>>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: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>
>>
>>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: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>
>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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message