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.
