Fwd: debug connection pool

2004-07-07 Thread Hans Wichman
Hi,
found it, sorry !
I had been searching in all the wrong directions, but the obvious one
grtz
Hans
Date: Wed, 07 Jul 2004 09:59:18 +0200
To: [EMAIL PROTECTED]
From: Hans Wichman [EMAIL PROTECTED]
Subject: debug connection pool
Hi,
does anyone know the correct way to debug a database connection pool, eg 
number of connections left in the pool etc?
Or a pointer in the right direction?
any help would be appreciated!

thanks!
Hans

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


debug connection pool

2004-07-07 Thread Hans Wichman
Hi,
does anyone know the correct way to debug a database connection pool, eg 
number of connections left in the pool etc?
Or a pointer in the right direction?
any help would be appreciated!

thanks!
Hans
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: Fwd: debug connection pool

2004-07-07 Thread Emerson Cargnin
So share your finding :)
Hans Wichman wrote:
Hi,
found it, sorry !
I had been searching in all the wrong directions, but the obvious one
grtz
Hans
Date: Wed, 07 Jul 2004 09:59:18 +0200
To: [EMAIL PROTECTED]
From: Hans Wichman [EMAIL PROTECTED]
Subject: debug connection pool
Hi,
does anyone know the correct way to debug a database connection pool, 
eg number of connections left in the pool etc?
Or a pointer in the right direction?
any help would be appreciated!

thanks!
Hans

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

a
--
Emerson Cargnin
Analista de Sistemas - Gerente Regional - Tubarão
Setor de Desenvolvimento de Sistemas - TRE-SC
tel : (048) - 251-3700 - Ramal 3181
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: Fwd: debug connection pool

2004-07-07 Thread Hans Wichman
Hiya,
jolly good plan ;-)
If you are using the dcbp commons, there are a couple of methods in the 
BasicDataSource class for getting this information.
So after retrieving the datasource from the context, test if it is a 
org.apache.commons.dbcp.BasicDataSource and if so cast it.
You can then use getNumActive, getMaxActive, getNumIdle, getMaxIdle etc to 
print this information before or after getting a connection.

grtz
Hans
At 02:12 PM 7/7/2004 -0300, Emerson Cargnin wrote:
So share your finding :)
Hans Wichman wrote:
Hi,
found it, sorry !
I had been searching in all the wrong directions, but the obvious one
grtz
Hans
Date: Wed, 07 Jul 2004 09:59:18 +0200
To: [EMAIL PROTECTED]
From: Hans Wichman [EMAIL PROTECTED]
Subject: debug connection pool
Hi,
does anyone know the correct way to debug a database connection pool, eg 
number of connections left in the pool etc?
Or a pointer in the right direction?
any help would be appreciated!

thanks!
Hans
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
a
--
Emerson Cargnin
Analista de Sistemas - Gerente Regional - Tubarão
Setor de Desenvolvimento de Sistemas - TRE-SC
tel : (048) - 251-3700 - Ramal 3181
-
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]