How Do I monitor connection pool programmatically in Jboss?

Question

I am working on project where there is a need to monitor connection pool usage like ActiveCount, AvailableCount, MaxUsedCount. I am struggling to find something useful. I know that connection pool craetes an MBean and binds it with the underlying available JMX server.This MBean will hold all the information about the connection pool. I want have access to this MBean so that I can access all attributes inside it.

However I know if I execute jboss-cli.sh in linux environment and execute

/subsystem=datasources/data-source=ExampleDS/statistics=pool:read-resource(include-runtime=true)

I will get below output

{
    "outcome" => "success",
    "result" => {
        "ActiveCount" => "0",
        "AvailableCount" => "20",
        "AverageBlockingTime" => "0",
        "AverageCreationTime" => "0",
        "CreatedCount" => "0",
        "DestroyedCount" => "0",
        "MaxCreationTime" => "0",
        "MaxUsedCount" => "0",
        "MaxWaitTime" => "0",
        "TimedOut" => "0",
        "TotalBlockingTime" => "0",
        "TotalCreationTime" => "0"
    }
}

Now same thing I wanted to achieve using programmatically. I am not sure how do I do this. Because I will run some program which will run at specific time interval and log connection data like ActiveCount, AvailableCount, MaxUsedCount which can be used further.

NOTE: I am using wilfly-9.0.1.Final

Please Guide.

score 2 · Answer 1 · edited May 23 '17 at 11:52

2

You can use CLI to get these statistics. To do so execute it from code as terminal command and parse result.

Also there is The HTTP management API and The native management API

edited May 23 '17 at 11:52

Community

1
1

answered May 25 '16 at 12:12

Abylay Sabirgaliyev

726
9
18

Thanks for you response. Is there any way through which I can log connection pool count ? – mahendra kawde May 25 '16 at 13:40
1

Look for JCA (Java EE Connector Architecture) logging here http://middlewaremagic.com/jboss/?p=1050 , though it is debug level. – Abylay Sabirgaliyev May 25 '16 at 14:16
I tried this but could not find anything in the log. – mahendra kawde May 26 '16 at 05:38
Set root-logger level to TRACE too. – Abylay Sabirgaliyev May 26 '16 at 05:44
It is logging now. But every time I get ActiveCount, AvailableCount as zero even if 2 is in use and max size is 30. So I suppose if in use count is 2 and max size is 30 I should see ActiveCount 3 and AvailableCount 27. But I am seeing all zero. What is wrong now ? – mahendra kawde May 26 '16 at 09:24
Check pool name in the log. Is it the pool you are looking for? If so, compare stats with web console stats. – Abylay Sabirgaliyev May 26 '16 at 09:47
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/113010/discussion-between-mahendra-kawde-and-doge). – mahendra kawde May 26 '16 at 10:01

How Do I monitor connection pool programmatically in Jboss?

1 Answers1