Return-Path: 
 <tomcat-user-return-82977-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 66945 invoked from network); 6 Nov 2003 16:24:02 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 6 Nov 2003 16:24:02 -0000
Received: (qmail 90388 invoked by uid 500); 6 Nov 2003 16:23:11 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 90351 invoked by uid 500); 6 Nov 2003 16:23:11 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 90303 invoked from network); 6 Nov 2003 16:23:11 -0000
Received: from unknown (HELO warhawk.mpi.com) (63.244.250.133)
  by daedalus.apache.org with SMTP; 6 Nov 2003 16:23:11 -0000
Received: from lightning.mpi.com (lightning.mpi.com [63.244.252.11])
	by warhawk.mpi.com (Switch-2.2.8/Switch-2.2.6) with ESMTP id hA6GJZF16349
	for <tomcat-user@jakarta.apache.org>; Thu, 6 Nov 2003 11:19:35 -0500 (EST)
Received: from US-VS1.corp.mpi.com (us-be1.corp.mpi.com [63.244.252.30])
	by lightning.mpi.com (Switch-3.0.5/Switch-3.0.0) with ESMTP id hA6GLUFV018325
	for <tomcat-user@jakarta.apache.org>; Thu, 6 Nov 2003 11:21:39 -0500 (EST)
X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: =?iso-8859-1?Q?RE=3A_R=E9f=2E_=3A_RE=3A_dbcp_pool_size?=
Date: Thu, 6 Nov 2003 11:20:52 -0500
Message-ID: <9C5166762F311146951505C6790A9CF8013DF634@US-VS1.corp.mpi.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: =?iso-8859-1?Q?R=E9f=2E_=3A_RE=3A_dbcp_pool_size?=
Thread-Index: AcOkfc2yWFbwGhllREmOCjploAhzRQABBJuQ
From: "Shapira, Yoav" <Yoav.Shapira@mpi.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N


Howdy,
And you're saying the pool obeys your maxActive directive without a fa=
ctory?  What happens when you request the 21st connection when there a=
re 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=E9f. : RE: dbcp pool size
>
>Noop. Below is my config in context.xml. Try to use dbcp and pool ver=
sion
>1.1
>
>	<Resource name=3D"jdbc/abcd" auth=3D"Container"
>type=3D"javax.sql.DataSource"/>
>	<ResourceParams name=3D"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=E9f. : 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=E9f. : 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=E9pondre =E0 "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=3D"jdbc/recProduit" auth=3D"Container"
>>>                        type=3D"javax.sql.DataSource"/>
>>>
>>>            <ResourceParams name=3D"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 l=
e
>>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 d=
elete
>>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, disclose=
d or
>used by anyone else.  If you are not the(an) intended recipient, plea=
se
>immediately delete this e-mail from your computer system and notify t=
he
>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 com=
munication, and may contain information that is confidential, propriet=
ary and/or privileged.  This e-mail is intended only for the individua=
l(s) to whom it is addressed, and may not be saved, copied, printed, d=
isclosed or used by anyone else.  If you are not the(an) intended reci=
pient, 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