Réf. : RE: Réf. : RE: dbcp pool size

2003-11-12 Thread meissa . Sakho 

Not sure you won't get it.

Because I'm getting it in any way. Specifiying it or not.

This parameter is implicit.

Meissa Sakho
NATEXIS ASSET MANAGEMENT
Direction de l'organisation
Tel. : 01 58 19 45 71
http://www.assetmanagement.natexis.fr





Shapira, Yoav [EMAIL PROTECTED]
10/11/2003 15:47
Veuillez répondre à Tomcat Users List


Pour :  Tomcat Users List [EMAIL PROTECTED]
cc :
Objet : RE: Réf. : RE: dbcp pool size



Howdy,
This is OK, and hopefully you won't get the same error.  Why don't you
test it out? ;)

Yoav Shapira
Millennium ChemInformatics


-Original Message-
From: Kenneth [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 7:43 AM
To: Tomcat Users List
Subject: Re: Réf. : RE: dbcp pool size

Sorry, but I'm quite new to this, and I'd like to know if I'm doing it
OK.
I'm using dbcp with mySQL and I always specify this parameter:

parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter

Is this OK?  Will I get the same error Meissa does?

Thanks.

Ken


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




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.

RE: Réf. : RE: dbcp pool size

2003-11-10 Thread Shapira, Yoav 

Howdy,
This is OK, and hopefully you won't get the same error.  Why don't you test it out? ;)

Yoav Shapira
Millennium ChemInformatics


-Original Message-
From: Kenneth [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 7:43 AM
To: Tomcat Users List
Subject: Re: Réf. : RE: dbcp pool size

Sorry, but I'm quite new to this, and I'd like to know if I'm doing it OK.
I'm using dbcp with mySQL and I always specify this parameter:

parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter

Is this OK?  Will I get the same error Meissa does?

Thanks.

Ken


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




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]

Re: Réf. : RE: dbcp pool size

2003-11-08 Thread Kenneth 
Sorry, but I'm quite new to this, and I'd like to know if I'm doing it OK.
I'm using dbcp with mySQL and I always specify this parameter:

parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter

Is this OK?  Will I get the same error Meissa does?

Thanks.

Ken


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Réf. : RE: Réf. : RE: dbcp pool size

2003-11-07 Thread meissa . Sakho 

when I request the 21st connection when there are 20 active connection,
the pool size grow to 21 and so and so.
And when the pool size reach the maximum number of connection authorized
by the database server.  Boom !

I have to restart tomcat and re initialize the pool.

I did not say the the pool obeys to anything without factory.
I simply want to know if it's a dbcp bug the the pool size is growing
without any
limit or if my configuration misses something.

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 17:20
Veuillez répondre à Tomcat Users List


Pour :  Tomcat Users List [EMAIL PROTECTED]
cc :
Objet : 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:[EMAIL PROTECTED]
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
namedriverClassName/name
 valueoracle.jdbc.driver.OracleDriver/value
/parameter
parameter
nameurl/name
valuejdbc:oracle:thin:@your.com:1521:SID/value
/parameter
parameter
nameusername/name
valueusername/value
/parameter
parameter
namepassword/name
valuepassword/value
/parameter
parameter
namemaxActive/name
value20/value
/parameter
parameter
namemaxIdle/name
value10/value
/parameter
parameter
nameminIdle/name
value10/value
/parameter
parameter
namemaxWait/name
value15000/value
/parameter
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
namelogAbandoned/name
valuetrue/value
/parameter
parameter
namevalidationQuery/name
valueSELECT SYSDATE FROM DUAL/value
/parameter
parameter
nametestOnBorrow/name
valuetrue/value
/parameter
parameter
nameminEvictableIdleTimeMillis/name
value-1/value
/parameter
!-- sleeps 5 minutes --
parameter
 nametimeBetweenEvictionRunsMillis/name
value30/value
/parameter
parameter
namenumTestsPerEvictionRun/name
value1/value
/parameter
parameter
nametestWhileIdle/name
valuetrue/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


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 8:12 AM
To: [EMAIL PROTECTED]
Subject: dbcp

Réf. : RE: Réf. : RE: dbcp pool size

2003-11-07 Thread meissa . Sakho 

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 [EMAIL PROTECTED]
06/11/2003 18:13
Veuillez répondre à Tomcat Users List


Pour :  'Tomcat Users List' [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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
   namedriverClassName/name
 valueoracle.jdbc.driver.OracleDriver/value
   /parameter
   parameter
   nameurl/name
   valuejdbc:oracle:thin:@your.com:1521:SID/value
   /parameter
   parameter
   nameusername/name
   valueusername/value
   /parameter
   parameter
   namepassword/name
   valuepassword/value
   /parameter
   parameter
   namemaxActive/name
   value20/value
   /parameter
   parameter
   namemaxIdle/name
   value10/value
   /parameter
   parameter
   nameminIdle/name
   value10/value
   /parameter
   parameter
   namemaxWait/name
   value15000/value
   /parameter
   parameter
   nameremoveAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namelogAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namevalidationQuery/name
   valueSELECT SYSDATE FROM DUAL/value
   /parameter
   parameter
   nametestOnBorrow/name
   valuetrue/value
   /parameter
   parameter
   nameminEvictableIdleTimeMillis/name
   value-1/value
   /parameter
   !-- sleeps 5 minutes --
   parameter
 nametimeBetweenEvictionRunsMillis/name
   value30/value
   /parameter
   parameter
   namenumTestsPerEvictionRun/name
   value1/value
   /parameter
   parameter
   nametestWhileIdle/name
   valuetrue/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

Réf. : RE: Réf. : RE: dbcp pool size

2003-11-07 Thread meissa . Sakho 

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
 namedriverClassName/name
 valueoracle.jdbc.driver.OracleDriver/value
 /parameter
 parameter
 nameurl/name
 valuejdbc:oracle:thin:@your.com:1521:SID/value
 /parameter
 parameter
 nameusername/name
 valueusername/value
 /parameter
 parameter
 namepassword/name
 valuepassword/value
 /parameter
 parameter
 namemaxActive/name
 value20/value
 /parameter
 parameter
 namemaxIdle/name
 value10/value
 /parameter
 parameter
 nameminIdle/name
 value10/value
 /parameter
 parameter
 namemaxWait/name
 value15000/value
 /parameter
 parameter
 nameremoveAbandoned/name
 valuetrue/value
 /parameter
 parameter
 namelogAbandoned/name
 valuetrue/value
 /parameter
 parameter
 namevalidationQuery/name
 valueSELECT SYSDATE FROM DUAL/value
 /parameter
 parameter
 nametestOnBorrow/name
 valuetrue/value
 /parameter
 parameter
 nameminEvictableIdleTimeMillis/name
 value-1/value
 /parameter
 !-- sleeps 5 minutes --
 parameter
 nametimeBetweenEvictionRunsMillis/name
 value30/value
 /parameter
 parameter
 namenumTestsPerEvictionRun/name
 value1/value
 /parameter
 parameter
 nametestWhileIdle/name
 valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail/value/para
mete

Re: Réf. : RE: Réf. : RE: dbcp pool size

2003-11-07 Thread Kwok Peng Tuck 
Hello, meissa, please have a look at the email I sent to the commons-list.

[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
namedriverClassName/name
valueoracle.jdbc.driver.OracleDriver/value
/parameter
parameter
nameurl/name
valuejdbc:oracle:thin:@your.com:1521:SID/value
/parameter
parameter
nameusername/name
valueusername/value
/parameter
parameter
namepassword/name
valuepassword/value
/parameter
parameter
namemaxActive/name
value20/value
/parameter
parameter
namemaxIdle/name
value10/value
/parameter
parameter
nameminIdle/name
value10/value
/parameter
parameter
namemaxWait/name
value15000/value
/parameter
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
namelogAbandoned/name
valuetrue/value
/parameter
parameter
namevalidationQuery/name
valueSELECT SYSDATE FROM DUAL/value
/parameter
parameter
nametestOnBorrow/name
valuetrue/value
/parameter
parameter
nameminEvictableIdleTimeMillis/name
value-1/value
/parameter
!-- sleeps 5 minutes --
parameter
nametimeBetweenEvictionRunsMillis/name
value30/value
/parameter
parameter
namenumTestsPerEvictionRun/name
value1/value
/parameter
parameter
nametestWhileIdle/name
valuetrue/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
   

-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
parameternameusername/namevaluemailer/value/parameter
parameternamepassword/namevaluemail2002/value/parameter
 

parameternamemaxActive/namevalue3/value/parameter
   

  parameternamedriverClassName/name

 

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
   

  parameternameurl/name

valuejdbc:sybase:Tds:s198000BLAHBLAH:5000

RE: Réf. : RE: Réf. : RE: dbcp pool size

2003-11-07 Thread Phillip Qin 
I highly recommend you drop off dbcp and pool version 1.1 to
${catalina.home}/common/lib and remove old version from that directory
before we go any further into the pool discussion.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: November 7, 2003 2:42 AM
To: Tomcat Users List
Subject: Réf. : RE: Réf. : RE: dbcp pool size


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
 namedriverClassName/name
 valueoracle.jdbc.driver.OracleDriver/value
 /parameter
 parameter
 nameurl/name
 valuejdbc:oracle:thin:@your.com:1521:SID/value
 /parameter
 parameter
 nameusername/name
 valueusername/value
 /parameter
 parameter
 namepassword/name
 valuepassword/value
 /parameter
 parameter
 namemaxActive/name
 value20/value
 /parameter
 parameter
 namemaxIdle/name
 value10/value
 /parameter
 parameter
 nameminIdle/name
 value10/value
 /parameter
 parameter
 namemaxWait/name
 value15000/value
 /parameter
 parameter
 nameremoveAbandoned/name
 valuetrue/value
 /parameter
 parameter
 namelogAbandoned/name
 valuetrue/value
 /parameter

 parameter
 namevalidationQuery/name
 valueSELECT SYSDATE FROM DUAL/value
 /parameter
 parameter
 nametestOnBorrow/name
 valuetrue/value
 /parameter
 parameter
 nameminEvictableIdleTimeMillis/name
 value-1/value
 /parameter
 !-- sleeps 5 minutes --
 parameter
 nametimeBetweenEvictionRunsMillis/name
 value30/value
 /parameter
 parameter
 namenumTestsPerEvictionRun/name
 value1/value
 /parameter
 parameter
 nametestWhileIdle/name
 valuetrue/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


-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

Réf. : RE: dbcp pool size

2003-11-06 Thread meissa . Sakho 

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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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: [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.

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Shapira, Yoav 

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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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: [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]

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Phillip Qin 
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
namedriverClassName/name
valueoracle.jdbc.driver.OracleDriver/value
/parameter
parameter
nameurl/name
valuejdbc:oracle:thin:@your.com:1521:SID/value
/parameter
parameter
nameusername/name
valueusername/value
/parameter
parameter
namepassword/name
valuepassword/value
/parameter
parameter
namemaxActive/name
value20/value
/parameter
parameter
namemaxIdle/name
value10/value
/parameter
parameter
nameminIdle/name
value10/value
/parameter
parameter
namemaxWait/name
value15000/value
/parameter
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
namelogAbandoned/name
valuetrue/value
/parameter
parameter
namevalidationQuery/name
valueSELECT SYSDATE FROM DUAL/value
/parameter
parameter
nametestOnBorrow/name
valuetrue/value
/parameter
parameter
nameminEvictableIdleTimeMillis/name
value-1/value
/parameter
!-- sleeps 5 minutes --
parameter
nametimeBetweenEvictionRunsMillis/name
value30/value
/parameter
parameter
namenumTestsPerEvictionRun/name
value1/value
/parameter
parameter
nametestWhileIdle/name
valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Shapira, Yoav 

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:[EMAIL PROTECTED]
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
   namedriverClassName/name
   valueoracle.jdbc.driver.OracleDriver/value
   /parameter
   parameter
   nameurl/name
   valuejdbc:oracle:thin:@your.com:1521:SID/value
   /parameter
   parameter
   nameusername/name
   valueusername/value
   /parameter
   parameter
   namepassword/name
   valuepassword/value
   /parameter
   parameter
   namemaxActive/name
   value20/value
   /parameter
   parameter
   namemaxIdle/name
   value10/value
   /parameter
   parameter
   nameminIdle/name
   value10/value
   /parameter
   parameter
   namemaxWait/name
   value15000/value
   /parameter
   parameter
   nameremoveAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namelogAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namevalidationQuery/name
   valueSELECT SYSDATE FROM DUAL/value
   /parameter
   parameter
   nametestOnBorrow/name
   valuetrue/value
   /parameter
   parameter
   nameminEvictableIdleTimeMillis/name
   value-1/value
   /parameter
   !-- sleeps 5 minutes --
   parameter
   nametimeBetweenEvictionRunsMillis/name
   value30/value
   /parameter
   parameter
   namenumTestsPerEvictionRun/name
   value1/value
   /parameter
   parameter
   nametestWhileIdle/name
   valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Phillip Qin 
I use tomcat, so there is a default factory class defined,
BasicDataSourceFactory?

-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED] 
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:[EMAIL PROTECTED]
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
   namedriverClassName/name
   valueoracle.jdbc.driver.OracleDriver/value
   /parameter
   parameter
   nameurl/name
   valuejdbc:oracle:thin:@your.com:1521:SID/value
   /parameter
   parameter
   nameusername/name
   valueusername/value
   /parameter
   parameter
   namepassword/name
   valuepassword/value
   /parameter
   parameter
   namemaxActive/name
   value20/value
   /parameter
   parameter
   namemaxIdle/name
   value10/value
   /parameter
   parameter
   nameminIdle/name
   value10/value
   /parameter
   parameter
   namemaxWait/name
   value15000/value
   /parameter
   parameter
   nameremoveAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namelogAbandoned/name
   valuetrue/value
   /parameter
   parameter
   namevalidationQuery/name
   valueSELECT SYSDATE FROM DUAL/value
   /parameter
   parameter
   nametestOnBorrow/name
   valuetrue/value
   /parameter
   parameter
   nameminEvictableIdleTimeMillis/name
   value-1/value
   /parameter
   !-- sleeps 5 minutes --
   parameter
   nametimeBetweenEvictionRunsMillis/name
   value30/value
   /parameter
   parameter
   namenumTestsPerEvictionRun/name
   value1/value
   /parameter
   parameter
   nametestWhileIdle/name
   valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Shapira, Yoav 

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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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
  namedriverClassName/name
  valueoracle.jdbc.driver.OracleDriver/value
  /parameter
  parameter
  nameurl/name
  valuejdbc:oracle:thin:@your.com:1521:SID/value
  /parameter
  parameter
  nameusername/name
  valueusername/value
  /parameter
  parameter
  namepassword/name
  valuepassword/value
  /parameter
  parameter
  namemaxActive/name
  value20/value
  /parameter
  parameter
  namemaxIdle/name
  value10/value
  /parameter
  parameter
  nameminIdle/name
  value10/value
  /parameter
  parameter
  namemaxWait/name
  value15000/value
  /parameter
  parameter
  nameremoveAbandoned/name
  valuetrue/value
  /parameter
  parameter
  namelogAbandoned/name
  valuetrue/value
  /parameter
  parameter
  namevalidationQuery/name
  valueSELECT SYSDATE FROM DUAL/value
  /parameter
  parameter
  nametestOnBorrow/name
  valuetrue/value
  /parameter
  parameter
  nameminEvictableIdleTimeMillis/name
  value-1/value
  /parameter
  !-- sleeps 5 minutes --
  parameter
  nametimeBetweenEvictionRunsMillis/name
  value30/value
  /parameter
  parameter
  namenumTestsPerEvictionRun/name
  value1/value
  /parameter
  parameter
  nametestWhileIdle/name
  valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name

valuejdbc: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

RE: Réf. : RE: dbcp pool size

2003-11-06 Thread Phillip Qin 
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:[EMAIL PROTECTED] 
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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
  namedriverClassName/name
  valueoracle.jdbc.driver.OracleDriver/value
  /parameter
  parameter
  nameurl/name
  valuejdbc:oracle:thin:@your.com:1521:SID/value
  /parameter
  parameter
  nameusername/name
  valueusername/value
  /parameter
  parameter
  namepassword/name
  valuepassword/value
  /parameter
  parameter
  namemaxActive/name
  value20/value
  /parameter
  parameter
  namemaxIdle/name
  value10/value
  /parameter
  parameter
  nameminIdle/name
  value10/value
  /parameter
  parameter
  namemaxWait/name
  value15000/value
  /parameter
  parameter
  nameremoveAbandoned/name
  valuetrue/value
  /parameter
  parameter
  namelogAbandoned/name
  valuetrue/value
  /parameter
  parameter
  namevalidationQuery/name
  valueSELECT SYSDATE FROM DUAL/value
  /parameter
  parameter
  nametestOnBorrow/name
  valuetrue/value
  /parameter
  parameter
  nameminEvictableIdleTimeMillis/name
  value-1/value
  /parameter
  !-- sleeps 5 minutes --
  parameter
  nametimeBetweenEvictionRunsMillis/name
  value30/value
  /parameter
  parameter
  namenumTestsPerEvictionRun/name
  value1/value
  /parameter
  parameter
  nametestWhileIdle/name
  valuetrue/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


-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
 parameternameusername/namevaluemailer/value/parameter
 parameternamepassword/namevaluemail2002/value/parameter

parameternamemaxActive/namevalue3/value/parameter
parameternamedriverClassName/name

valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name