tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From andy gordon <>
Subject RE: How to test connection pooling
Date Tue, 29 Nov 2005 16:57:35 GMT
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" <> 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 [] 
>Sent: Tuesday, November 29, 2005 10:45 AM
>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 ?
>Start your day with Yahoo! - Make it your home page! 
>To unsubscribe, e-mail:
>For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message