Get Available connection via java code

[gurusathish]

Hi All,

I am able to see the available, max used, active and idle connection in Wildfly Adminstraion console.

So now  I want to print the available connection in WildFly 8.2.0 Final, via java code it self. Is it possible ? if it is please help me..................

I want like the following out put printed on the console each time we get the connection and closing the connection

Assume Max connection : 100

Getting Connection : 1 , Available connection : 99

Releasing Connection : 1 , Available connection : 100

Thanks in advancd !

[mayerw01]

You may read the statistics via cli, like:

../jboss-cli.sh  --connect --command='/subsystem=datasources/data-source=ExampleDS/statistics=pool:read-attribute(name=AvailableCount)'

./jboss-cli.sh  --connect --command='/subsystem=datasources/data-source=ExampleDS/statistics=pool:read-attribute(name=InUseCount)'

[gurusathish]

Hi Wolfgang Mayer,

Thank you for your response....

My requirement is to get available connection printed via java code , so that i can easily find out where the connection is reduced. So please help in getting num.of available connection via java code and printed on the console.

Thanks............

[mayerw01]

If the statistics are enabled it should be possible to get these values via MBeans like

jboss.as:subsystem=datasources,xa-data-source=datasourcename,statistics=pool

[gurusathish]

Hi Wolfgang Mayer,

Thank you for your response.... I will try this and will give you a feed back............