tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From meissa.Sa...@assetmanagement.natexis.fr
Subject Réf. : RE: Réf. : RE: dbcp pool size
Date Fri, 07 Nov 2003 07:35:58 GMT

Pilllip,
I've posted the question to the common list too.
And I'm still waiting for a suggestion.
If you have a solution, please let me know.
I I've not set the factory parameter because is it the BasicDataSourceFactory .
I don't see the reason why my pool size is growing with no limit.


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 18:13
Veuillez répondre à "Tomcat Users List"


        Pour :  "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
        cc :
        Objet : RE: Réf. : RE: dbcp pool size


Agree. There isn't a default factory class because the class IS
BasicDataSourceFactory if you look at the tomcat code (correct me if I am
wrong).

>From my "numerous" failures in pool implementation, I found that the
problem
can be solved by proper config of dbcp and pool. I suggest Meissa post
question to commons user list. One of the developers of dbcp Dirk is very
helpful.

-----Original Message-----
From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
Sent: November 6, 2003 11:58 AM
To: Tomcat Users List
Subject: RE: Réf. : RE: dbcp pool size


Howdy,
Um, no there isn't such a default factory defined, and you didn't answer
my
questions ;)

Yoav Shapira
Millennium ChemInformatics


>-----Original Message-----
>From: Phillip Qin [mailto:Phillip.Qin@shareowner.com]
>Sent: Thursday, November 06, 2003 11:40 AM
>To: 'Tomcat Users List'
>Subject: RE: Réf. : RE: dbcp pool size
>
>I use tomcat, so there is a default factory class defined,
>BasicDataSourceFactory?
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: November 6, 2003 11:21 AM
>To: Tomcat Users List
>Subject: RE: Réf. : RE: dbcp pool size
>
>
>Howdy,
>And you're saying the pool obeys your maxActive directive without a
>factory?
>What happens when you request the 21st connection when there are already
20
>active?
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
>>-----Original Message-----
>>From: Phillip Qin [mailto:Phillip.Qin@shareowner.com]
>>Sent: Thursday, November 06, 2003 10:52 AM
>>To: 'Tomcat Users List'
>>Subject: 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
>
>
>
>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



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.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message