-
1. Re: Datasource connection count monitoring
nickarls Dec 9, 2011 7:10 AM (in response to ajazam)tried the CLI :read-resource(include-runtime=true) for the DS?
-
2. Re: Datasource connection count monitoring
jesper.pedersen Dec 9, 2011 7:22 AM (in response to ajazam)Watch pull request 852.
-
3. Re: Datasource connection count monitoring
ajazam Dec 9, 2011 7:26 AM (in response to nickarls)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
nickarls Dec 9, 2011 7:30 AM (in response to ajazam)1 of 1 people found this helpful[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)
-
5. Re: Datasource connection count monitoring
ajazam Dec 9, 2011 9:45 AM (in response to nickarls)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
ajazam Dec 9, 2011 9:44 AM (in response to jesper.pedersen)Hello Jesper,
Hasn't pull request 852 already been resolved (https://issues.jboss.org/browse/AS7-852)?
-
7. Re: Datasource connection count monitoring
jesper.pedersen Dec 9, 2011 9:54 AM (in response to ajazam)https://github.com/jbossas/jboss-as/pull/852 -- its AS7-1994.
-
8. Re: Datasource connection count monitoring
ajazam Dec 9, 2011 9:59 AM (in response to jesper.pedersen)Thanks for that Jesper.