2 Replies Latest reply on Dec 5, 2015 11:19 AM by Jay SenSharma


    Sigitas M Newbie


      How I can monitoring jdbc connection pol  "connection-url>jdbc:oracle:thin:@aa.bbb.cc.com:1522:ddd111spc1</connection-url>

      jbos version EAP 6.2 /monitoring tool java/jmc



        • 1. Re: Hello
          Jay SenSharma Master

          Not sure what do you mean by "jbos version EAP 6.2 /monitoring tool java/jmc" ?


          However you can easily monitor the DataSource using the following kind of CLI Commands ($JBOSS_HOME/bin/jboss-cli.sh):


          [standalone@localhost:9999 /] /subsystem=datasources/data-source=ExampleDS/statistics=pool:write-attribute(name=statistics-enabled,value=true)
          {"outcome" => "success"}
          [standalone@localhost:9999 /] /subsystem=datasources/data-source=ExampleDS/statistics=pool:read-resource(include-runtime=true,include-defaults=true,recursive=true)
              "outcome" => "success",
              "result" => {
                  "ActiveCount" => "0",
                  "AvailableCount" => "20",
                  "AverageBlockingTime" => "0",
                  "AverageCreationTime" => "0",
                  "CreatedCount" => "0",
                  "DestroyedCount" => "0",
                  "InUseCount" => "0",
                  "MaxCreationTime" => "0",
                  "MaxUsedCount" => "0",
                  "MaxWaitCount" => "0",
                  "MaxWaitTime" => "0",
                  "TimedOut" => "0",
                  "TotalBlockingTime" => "0",
                  "TotalCreationTime" => "0",
                  "statistics-enabled" => true
          • 2. Re: Hello
            Jay SenSharma Master

            By JMC you mean Java Mission Control which is present inside the "$JAVA_HOME/bin/jmc".  Then this JMC startup is controlled by options specified in the "jmc.ini" file, which is located in the "JAVA_HOME/bin" directory.


            So please try this:


            Edit the "$JAVA_HOME//bin/jmc.ini" file and add the "jboss-client.jar" as following in it:




            Then start the "jmc" and then create a new connection using the URL as following (for example here "localhost" is the JBoss Management Address or specify the IP Address if you started your JBoss Management interface or the remoting address of server.




            Then navigate the MBean browser present in the JMC console  and there you should be able to see the DataSource related data.