8 Replies Latest reply on Dec 9, 2011 9:59 AM by Jabbar Azam

    Datasource connection count monitoring

    Jabbar Azam Newbie

      Hello,

       

      Is it possible to monitor the connection count for a particular datasource? I need to know if the idle connection timeout is working in Jboss AS 7 and what the connection count for a particular datasource is? I have spent a number of hours trying to find and are resorting to the forum now.

        • 1. Re: Datasource connection count monitoring
          Nicklas Karlsson Master

          tried the CLI :read-resource(include-runtime=true) for the DS?

          • 3. Re: Datasource connection count monitoring
            Jabbar Azam Newbie

            Hello Nicklas,

             

            Thank you for your reply.

             

            I'm using jboss-as-7.0.2.

             

            Using the CLI I get

            from /

             

            [standalone@172.16.1.15:9999 /] :read-resource(include-runtime=true)

            {

                "outcome" => "success",

                "result" => {

                    "launch-type" => "STANDALONE",

                    "name" => "ajazam-333",

                    "namespaces" => [],

                    "path" => undefined,

                    "process-type" => "Server",

                    "profile-name" => undefined,

                    "schema-locations" => [],

                    "server-state" => "running",

                    "system-property" => undefined,

                    "core-service" => {

                        "platform-mbean" => undefined,

                        "service-container" => undefined,

                        "management" => undefined

                    },

                    "deployment" => {"wwater.ear" => undefined},

                    "extension" => {

                        "org.jboss.as.weld" => undefined,

                        "org.jboss.as.ejb3" => undefined,

                        "org.jboss.as.jpa" => undefined,

                        "org.jboss.as.naming" => undefined,

                        "org.jboss.as.security" => undefined,

                        "org.jboss.as.ee" => undefined,

                        "org.jboss.as.pojo" => undefined,

                        "org.jboss.as.clustering.infinispan" => undefined,

                        "org.jboss.as.sar" => undefined,

                        "org.jboss.as.deployment-scanner" => undefined,

                        "org.jboss.as.threads" => undefined,

                        "org.jboss.as.web" => undefined,

                        "org.jboss.as.osgi" => undefined,

                        "org.jboss.as.remoting" => undefined,

                        "org.jboss.as.jaxrs" => undefined,

                        "org.jboss.as.logging" => undefined,

                        "org.jboss.as.jmx" => undefined,

                        "org.jboss.as.transactions" => undefined,

                        "org.jboss.as.connector" => undefined

                    },

                    "interface" => {

                        "public" => undefined,

                        "management" => undefined

                    },

                    "socket-binding-group" => {"standard-sockets" => undefined},

                    "subsystem" => {

                        "jca" => undefined,

                        "transactions" => undefined,

                        "naming" => undefined,

                        "weld" => undefined,

                        "jmx" => undefined,

                        "remoting" => undefined,

                        "jpa" => undefined,

                        "web" => undefined,

                        "logging" => undefined,

                        "security" => undefined,

                        "pojo" => undefined,

                        "osgi" => undefined,

                        "deployment-scanner" => undefined,

                        "resource-adapters" => undefined,

                        "datasources" => undefined,

                        "ee" => undefined,

                        "threads" => undefined,

                        "infinispan" => undefined,

                        "sar" => undefined,

                        "ejb3" => undefined,

                        "jaxrs" => undefined

                    }

                }

            }

             

             

            If I do

            cd /subsystem=datasources

             

            running

             

            :read-resource(include-runtime=true)

             

            I get

            {

                "outcome" => "success",

                "result" => {

                    "xa-data-source" => undefined,

                    "data-source" => {

                        "java:jboss/datasources/ExampleDS" => undefined,

                        "java:/webpmac" => undefined

                    },

                    "jdbc-driver" => {

                        "h2" => undefined,

                        "mysql" => undefined

                    }

                }

            }

             

            Is there anywhere else I can look?

            • 4. Re: Datasource connection count monitoring
              Nicklas Karlsson Master

              [standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/da

              java\:jboss\/datasources\/ExampleDS:read-resource(include-runtime=true)

              {

                  "outcome" => "success",

                  "result" => {

                      "ActiveCount" => "0",

                      "AvailableCount" => "20",

                      "AverageBlockingTime" => "0",

                      "AverageCreationTime" => "0",

                      "CreatedCount" => "0",

                      "DestroyedCount" => "0",

                      "MaxCreationTime" => "0",

                      "MaxUsedCount" => "0",

                      "MaxWaitCount" => "0",

                      "MaxWaitTime" => "0",

                      "PreparedStatementCacheAccessCount" => "0",

                      "PreparedStatementCacheAddCount" => "0",

                      "PreparedStatementCacheCurrentSize" => "0",

                      "PreparedStatementCacheDeleteCount" => "0",

                      "PreparedStatementCacheHitCount" => "0",

                      "PreparedStatementCacheMissCount" => "0",

                      "TimedOut" => "0",

                      "TotalBlockingTime" => "0",

                      "TotalCreationTime" => "0",

                      "allocation-retry" => undefined,

                      "allocation-retry-wait-millis" => undefined,

                      "background-validation" => undefined,

                      "background-validation-millis" => undefined,

                      "blocking-timeout-wait-millis" => undefined,

                      "check-valid-connection-sql" => undefined,

                      "connection-properties" => undefined,

                      "connection-url" => "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1",

                      "datasource-class" => undefined,

                      "driver-class" => undefined,

                      "driver-name" => "h2",

                      "enabled" => true,

                      "exception-sorter-class-name" => undefined,

                      "exception-sorter-properties" => undefined,

                      "flush-strategy" => undefined,

                      "idle-timeout-minutes" => undefined,

                      "jndi-name" => "java:jboss/datasources/ExampleDS",

                      "jta" => true,

                      "max-pool-size" => undefined,

                      "min-pool-size" => undefined,

                      "new-connection-sql" => undefined,

                      "password" => "sa",

                      "pool-name" => "H2DS",

                      "pool-prefill" => undefined,

                      "pool-use-strict-min" => undefined,

                      "prepared-statements-cache-size" => undefined,

                      "query-timeout" => undefined,

                      "reauth-plugin-class-name" => undefined,

                      "reauth-plugin-properties" => undefined,

                      "security-domain" => undefined,

                      "set-tx-query-timeout" => "false",

                      "share-prepared-statements" => "false",

                      "spy" => false,

                      "stale-connection-checker-class-name" => undefined,

                      "stale-connection-checker-properties" => undefined,

                      "track-statements" => "\"NOWARN\"",

                      "transaction-isolation" => undefined,

                      "url-delimiter" => undefined,

                      "url-selector-strategy-class-name" => undefined,

                      "use-ccm" => true,

                      "use-fast-fail" => "false",

                      "use-java-context" => true,

                      "use-try-lock" => undefined,

                      "user-name" => "sa",

                      "valid-connection-checker-class-name" => undefined,

                      "valid-connection-checker-properties" => undefined,

                      "validate-on-match" => "false"

                  }

              }

               

              (use tab completion, it's the easiest way along the path)

              1 of 1 people found this helpful
              • 5. Re: Datasource connection count monitoring
                Jabbar Azam Newbie

                Hello Nicklas,

                 

                Sorry for the delay but I couldn't get your example working. I'm a newbie regarding the CLI stuff.

                I followed your suggestion and got

                 

                [standalone@172.16.1.15:9999 datasource=datasources] /subsystem=datasources/datasource="java\:/webpmac":read-resource(include-runtime=true)

                {

                    "outcome" => "failed",

                    "failure-description" => "No handler for operation read-resource at address [

                    (\"subsystem\" => \"datasources\"),

                    (\"datasource\" => \"java:/webpmac\")

                ]",

                    "rolled-back" => true

                }

                • 6. Re: Datasource connection count monitoring
                  Jabbar Azam Newbie

                  Hello Jesper,

                   

                  Hasn't pull request 852 already been resolved (https://issues.jboss.org/browse/AS7-852)?