Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of pete.lucuk@ngc.com designates
 208.12.122.38 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: How to test connection pooling
Date: Tue, 29 Nov 2005 14:22:09 -0500
Message-ID: <52F6AB54F39902489F13FEB65D9EB56D252117@XMBV4801.northgrum.com>
Thread-Topic: How to test connection pooling
Thread-Index: AcX1FRDALw4znBjVTH+Bwb00OCOBRQAA6J8A
From: "Lucuk, Pete" <pete.lucuk@ngc.com>
To: "Tomcat Users List" <users@tomcat.apache.org>

I used Tomcat 4.1 and got the.....

	"create only one connection at first and then create more
connections as needed"

behavior and it works fine, no errors.

Also, I am using Oracle 8i and use the Oracle jdbc driver ojdbc14.jar
Different that commons stuff you are using.

>-----Original Message-----
>From: Manisha Sathe [mailto:manisha_msathe@yahoo.com]=20
>Sent: Tuesday, November 29, 2005 1:44 PM
>To: Tomcat Users List
>Subject: RE: How to test connection pooling
>
>Hi,=20
>
>After some testing on Tomcat 5 / Tomcat 4.1, i am finding some=20
>strange behaviour.
>I could figure out how to check number of conections on MSSQL.=20
>It is Enterprise Manager -> Management -> Current Processes -=20
>u have to refresh it now and then.
>
>1)For Tomcat 5, it does create a pool of connections at start=20
>depending on initial size. And it uses it from those depending=20
>upon availability. I tested this using some big loops.
>
>2)But for Tomcat 4.1 - it does not create a pool of conections=20
>but only ONE connection. I thought if trafic increases it=20
>might add new connections to it.
>So again tested with 2 requests and used a big loop so that=20
>first request will make use of connection object for=20
>sufficient time and will not release it.=20
>
>I was expecting second request should create new connection in=20
>a pool, but it did not, it waited for existing connection to=20
>become free and later it gave error saying:
>--------------------
>Error message
>
>java.sql.SQLException: SQLException from connection
>manager: org.apache.commons.dbcp.SQLNestedException:
>Cannot get a connection, pool exhausted, cause:
>Timeout waiting for idle object
>--------------------------
>
>
>Now whether it means that Tomcat 4.1 does not create pooling=20
>at all ? Am i missing any settings ? For 4.1 am i suppose to=20
>use any different jars ?
>
>I even tested the same for MySQL. The result is same.
>Pls Pls help me, i am stuck like anything.
>
>regards
>Manisha
>
>--- andy gordon <efhajg0@yahoo.com> wrote:
>
>> Show Processlist will show the number of initial connections=20
>at start=20
>> but does it show what subsystem a connection is bound to? what if=20
>> there are multiple tomcat's connected to one database. How do you=20
>> differentiate?
>>=20
>> "Lucuk, Pete" <pete.lucuk@ngc.com> wrote:  Manisha,
>>=20
>> I do not know how you check in MSSQL.
>> But, just an FYI....
>>=20
>> If you setup your connection to ten, ten do not automatically get=20
>> created, only one, and as your app requires more connections, more=20
>> connections will be created up to a max of ten.
>>=20
>> Took me a couple days to figure out that one
>>=20
>> >-----Original Message-----
>> >From: Manisha Sathe
>> [mailto:manisha_msathe@yahoo.com]
>> >Sent: Tuesday, November 29, 2005 10:45 AM
>> >To: users@tomcat.apache.org
>> >Subject: How to test connection pooling
>> >
>> >I am on tomcat 4.1
>> >
>> >I am using JDBC connection pooling for MSSQL and
>> singleton
>> >class for JNDI lookup (only once) and get
>> connection.
>> >
>> >Everything is working file. But how to test that
>> connection
>> >pool for 10 (where initial size specified is 10)
>> has been created ?
>> >
>> >I know for mysql it is 'show processlist' and this
>> gives out
>> >initial number of connections at start. Same thing
>> how can i
>> >do it for mssql ?
>> >
>> >regards
>> >Manisha
>> >
>> >
>> >
>> >
>> >
>> >=20
>> >__________________________________
>> >Start your day with Yahoo! - Make it your home
>> page!=20
>> >http://www.yahoo.com/r/hs
>> >
>>
>>---------------------------------------------------------------------
>> >To unsubscribe, e-mail:
>> users-unsubscribe@tomcat.apache.org
>> >For additional commands, e-mail:
>> users-help@tomcat.apache.org
>> >
>> >
>>=20
>>
>---------------------------------------------------------------------
>> To unsubscribe, e-mail:
>> users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail:
>> users-help@tomcat.apache.org
>>=20
>>=20
>>=20
>>=20
>> 	=09
>> ---------------------------------
>>  Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>
>
>
>	=09
>__________________________________
>Yahoo! Music Unlimited
>Access over 1 million songs. Try it free.=20
>http://music.yahoo.com/unlimited/
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org