Thread: [c3p0-users] [JMX] Number of PoolDataSources is different from NumPooledDataSources
Status: Beta
Brought to you by:
swaldman
From: stlecho <st...@gm...> - 2009-04-21 14:17:48
|
Hi, When using JMX to get information about the pooled connections, I've remarked that the number of PoolDataSources shown in "com.mchange.v2.c3po" is the double of the NumPooledDataSources. When checking the details of each PooledDataSources, I've remarked that for 1 jdbcURL 2 PoolDataSources are shown with a different dataSourceName and identityToken. Is this normal ? Example: -com.mchange.v2.c3po.C3P0Registry.NumPooledDataSources: 4 -com.mchange.v2.c3po.C3P0Registry.NumPoolsAllDataSources: 4 -com.mchange.v2.c3po.PoolDataSources: 8 Regards, Stefan Lecho. -- View this message in context: http://www.nabble.com/-JMX--Number-of-PoolDataSources-is-different-from-NumPooledDataSources-tp23157118p23157118.html Sent from the c3p0 - users mailing list archive at Nabble.com. |
From: stlecho <st...@gm...> - 2009-05-06 14:32:26
|
> There are lots of JMX beans exposed. We didn't try to write code to > navigate them all, we just find the ones we wanted to watch, and then > wrote code that looked at the settings on that one, watching for problems. > I understand, but ... Why is the number of PoolDataSources shown in "com.mchange.v2.c3po" is the double of the NumPooledDataSources ? Why for each jdbcURL 2 PoolDataSources are shown with a different dataSourceName and identityToken ? stlecho wrote: > > Hi, > > When using JMX to get information about the pooled connections, I've > remarked that the number of PoolDataSources shown in "com.mchange.v2.c3po" > is the double of the NumPooledDataSources. > > When checking the details of each PooledDataSources, I've remarked that > for 1 jdbcURL 2 PoolDataSources are shown with a different dataSourceName > and identityToken. > > Is this normal ? > > Example: > -com.mchange.v2.c3po.C3P0Registry.NumPooledDataSources: 4 > -com.mchange.v2.c3po.C3P0Registry.NumPoolsAllDataSources: 4 > -com.mchange.v2.c3po.PoolDataSources: 8 > > Regards, Stefan Lecho. > > > > -- View this message in context: http://www.nabble.com/-JMX--Number-of-PoolDataSources-is-different-from-NumPooledDataSources-tp23157118p23407598.html Sent from the c3p0 - users mailing list archive at Nabble.com. |
From: jdsumsion <jds...@gm...> - 2009-05-11 22:12:01
|
I'm not an expert on how c3p0 does its password-protected pools. I found the following under "Known Shortcomings" in c3p0 doc: http://tom.tharrisx.homedns.org/javalib/c3p0-0.8.4.5/doc/#known_shortcomings stlecho wrote: > > > >> There are lots of JMX beans exposed. We didn't try to write code to >> navigate them all, we just find the ones we wanted to watch, and then >> wrote code that looked at the settings on that one, watching for >> problems. >> > > I understand, but ... > > Why is the number of PoolDataSources shown in "com.mchange.v2.c3po" is the > double of the NumPooledDataSources ? > > Why for each jdbcURL 2 PoolDataSources are shown with a different > dataSourceName and identityToken ? > -- View this message in context: http://www.nabble.com/-JMX--Number-of-PoolDataSources-is-different-from-NumPooledDataSources-tp23157118p23492449.html Sent from the c3p0 - users mailing list archive at Nabble.com. |