tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Trond Hersløv <trond.hers...@GOTOGATE.no>
Subject RE: db-connectin is working fine, but is it pooling?
Date Fri, 23 Sep 2005 21:43:14 GMT
Hi
Thanks Pete. That seems to be the case.

\trond
 

-----Original Message-----
From: Lucuk, Pete [mailto:pete.lucuk@ngc.com] 
Sent: 23. september 2005 17:43
To: Tomcat Users List
Subject: RE: db-connectin is working fine, but is it pooling?


I had a similar question while doing connection pooling with Oracle 8i of.....

	OK, if I set my connection pool to 10, why do I only see a 1 connection in Oracle

Well, the answer was that when you create a pool of 10, it only starts out with 1 connection,
NOT 10

If the connection pool starts needing more than 1 connection, it will create and *keep* new
connections.
Oracle's connection pooling jar was smart enough to do it.

I opened up 4 web browsers and hit my web based app like crazy and saw the acutal physical
connections in Oracle jump up to like 5 and stayed at 5 connections.

I assume it is the same in MySQL






>-----Original Message-----
>From: KEREM ERKAN [mailto:kerem.erkan@basari.com.tr]
>Sent: Friday, September 23, 2005 2:50 AM
>To: 'Tomcat Users List'
>Subject: RE: db-connectin is working fine, but is it pooling?
>
>
>Write a test connection page and stress test it with a lot of virtual
>clients. That way, you will have more than 1 connection opened 
>to ypur pool.
>
>
>> -----Original Message-----
>> From: Trond Hersløv [mailto:trond.herslov@GOTOGATE.no] 
>> Sent: Friday, September 23, 2005 3:24 AM
>> To: Tomcat Users List
>> Subject: RE: db-connectin is working fine, but is it pooling?
>> 
>> Thanks, I'll do that, but still - how can I be sure that my 
>> pool have more than just this one connection. Writing two 
>> servlets with endless loops, avoiding checking the 
>> connections back would give me the answer I guess.
>> But why is there only one connection established to my DB server??
>> 
>> Is there a way to configure the pool to pre generate eg. 10 
>> connections?
>> 
>> \trond
>> 
>> 
>> -----Original Message-----
>> From: Kyle [mailto:kl@attitia.com]
>> Sent: 23. september 2005 02:14
>> To: Tomcat Users List
>> Subject: Re: db-connectin is working fine, but is it pooling?
>> 
>> Print out your Connection Object .toString() to stdout or on 
>> a page and you should see that it is a Pool(ed|able) 
>> Connection object.
>> 
>> K
>> 
>> Trond Hersløv wrote:
>> 
>> >Everything works just fine, but I'm a little bit concerned 
>> that maybe I am generating a singel connection to the DB and 
>> not a pool of connections.
>> >As I run  netstat -a on the machine hosting the DB, I 
>> expected to find 
>> >a lot of connections to port 3306, which my MySQL server 
>> listens to, but there is only one single connection. Even 
>> when I press F5 for a long time to refresh my IE window like 
>> a 100 times or with more windows open at the same time there 
>> is just this one connection to be found.
>> >  
>> >
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>> 
>> 
>> 
>**********************************************************************
>> This email message has been swept by
>> MIMEsweeper for the presence of computer viruses.
>> 
>**********************************************************************
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>> 
>

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

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