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]