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:[EMAIL PROTECTED] >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:[EMAIL PROTECTED] >> 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:[EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >********************************************************************** >> This email message has been swept by >> MIMEsweeper for the presence of computer viruses. >> >********************************************************************** >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]