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] smime.p7s Description: S/MIME cryptographic signature
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:[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]
RE: db-connectin is working fine, but is it pooling?
Hi Thanks Pete. That seems to be the case. \trond -Original Message- From: Lucuk, Pete [mailto:[EMAIL PROTECTED] 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:[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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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]
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]
RE: db-connectin is working fine, but is it pooling?
I think (not sure as I am not a Tomcat expert) that you can just get 2 connections without closing either - and see that you got 2. - dave -Original Message- From: Trond Hersløv [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 6:24 PM 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]