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]
