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]