RE: How to test connection pooling - Resolved
I do not know when i am going to get over from such silly mistakes... but I was putting MaxActive - 1 ?? (whereas i wanted to put 100) Any way thanks a lot for trying to help me out regards Manisha --- Lucuk, Pete [EMAIL PROTECTED] wrote: So you mean to say you did not get error for second request and it created a new connection ? Yes, that is what I am saying (But this is for Oracle8i). Whether it means there is a problem for MSSQL ? Yeah, I do not know what it means for MSSQL. I know I have read the netbeans forums and people have head massive problems with MSSQL and Netbeans Tomcat regards Manisha --- Lucuk, Pete [EMAIL PROTECTED] wrote: 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:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 1:44 PM To: Tomcat Users List Subject: RE: How to test connection pooling Hi, After some testing on Tomcat 5 / Tomcat 4.1, i am finding some strange behaviour. I could figure out how to check number of conections on MSSQL. It is Enterprise Manager - Management - Current Processes - u have to refresh it now and then. 1)For Tomcat 5, it does create a pool of connections at start depending on initial size. And it uses it from those depending upon availability. I tested this using some big loops. 2)But for Tomcat 4.1 - it does not create a pool of conections but only ONE connection. I thought if trafic increases it might add new connections to it. So again tested with 2 requests and used a big loop so that first request will make use of connection object for sufficient time and will not release it. I was expecting second request should create new connection in a pool, but it did not, it waited for existing connection to 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 at all ? Am i missing any settings ? For 4.1 am i suppose to 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 [EMAIL PROTECTED] wrote: Show Processlist will show the number of initial connections at start but does it show what subsystem a connection is bound to? what if there are multiple tomcat's connected to one database. How do you differentiate? Lucuk, Pete [EMAIL PROTECTED] wrote: Manisha, I do not know how you check in MSSQL. But, just an FYI If you setup your connection to ten, ten do not automatically get created, only one, and as your app requires more connections, more connections will be created up to a max of ten. Took me a couple days to figure out that one -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] 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 __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs - 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] === message truncated === __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: How to test connection pooling
Manisha, I do not know how you check in MSSQL. But, just an FYI If you setup your connection to ten, ten do not automatically get created, only one, and as your app requires more connections, more connections will be created up to a max of ten. Took me a couple days to figure out that one -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] 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 __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs - 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: How to test connection pooling
Show Processlist will show the number of initial connections at start but does it show what subsystem a connection is bound to? what if there are multiple tomcat's connected to one database. How do you differentiate? Lucuk, Pete [EMAIL PROTECTED] wrote: Manisha, I do not know how you check in MSSQL. But, just an FYI If you setup your connection to ten, ten do not automatically get created, only one, and as your app requires more connections, more connections will be created up to a max of ten. Took me a couple days to figure out that one -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] 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 __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs - 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] - Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
RE: How to test connection pooling
Thanks for quick reply, So you mean to say you did not get error for second request and it created a new connection ? (But this is for Oracle8i). Whether it means there is a problem for MSSQL ? regards Manisha --- Lucuk, Pete [EMAIL PROTECTED] wrote: 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:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 1:44 PM To: Tomcat Users List Subject: RE: How to test connection pooling Hi, After some testing on Tomcat 5 / Tomcat 4.1, i am finding some strange behaviour. I could figure out how to check number of conections on MSSQL. It is Enterprise Manager - Management - Current Processes - u have to refresh it now and then. 1)For Tomcat 5, it does create a pool of connections at start depending on initial size. And it uses it from those depending upon availability. I tested this using some big loops. 2)But for Tomcat 4.1 - it does not create a pool of conections but only ONE connection. I thought if trafic increases it might add new connections to it. So again tested with 2 requests and used a big loop so that first request will make use of connection object for sufficient time and will not release it. I was expecting second request should create new connection in a pool, but it did not, it waited for existing connection to 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 at all ? Am i missing any settings ? For 4.1 am i suppose to 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 [EMAIL PROTECTED] wrote: Show Processlist will show the number of initial connections at start but does it show what subsystem a connection is bound to? what if there are multiple tomcat's connected to one database. How do you differentiate? Lucuk, Pete [EMAIL PROTECTED] wrote: Manisha, I do not know how you check in MSSQL. But, just an FYI If you setup your connection to ten, ten do not automatically get created, only one, and as your app requires more connections, more connections will be created up to a max of ten. Took me a couple days to figure out that one -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] 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 __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs - 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] - Yahoo! Music Unlimited - Access over 1 million songs. Try it free. __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ - 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] __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]