>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] >> >> >> >> >> >> >> >> >> >> >> >> --------------------------------- >> >> 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
