4 Replies Latest reply on Sep 1, 2015 3:03 AM by gurusathish

Get Available connection via java code

gurusathish Aug 27, 2015 12:31 PM

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 !

1. Re: Get Available connection via java code

mayerw01 Aug 28, 2015 7:39 AM (in response to gurusathish)

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)'
Actions
2. Re: Get Available connection via java code

gurusathish Aug 28, 2015 8:55 AM (in response to mayerw01)

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............
Actions
3. Re: Get Available connection via java code

mayerw01 Aug 31, 2015 8:56 AM (in response to gurusathish)

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
Actions
4. Re: Get Available connection via java code

gurusathish Sep 1, 2015 3:03 AM (in response to mayerw01)

Hi Wolfgang Mayer,

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

Go to original post