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]
