Why DataSource connection pool statistics values are not correct (always equal zero) in EAP 6
Issue
- Problem getting a managed connection from the pool in JBoss EAP 6
- When we monitored the connection pool using JConsole, we noticed that the active count had a negative value, what does that mean? We also noticed that there is blocking time despite the fact that the max count is not reached. Why is that? Is the DB driver compatible with JBoss? Or does it have a bug that keeps the db connections and doesn’t return them to the pool?
- Is data source statistics enabled by default in EAP 6.3?
-
Datasource statistics values are not correct (always equal zero) from
Jconsole? SinceEAP 6.3.3, we don't get correct datasource pool connection values via JMX interface. All Values about DS pool Connections:InUseCount, AvailableCount, MaxUsedCount, ActiveCount, etc.are equal zero. The values from following subsystem:
jboss.as:subsystem=datasources,xa-data-source=Name_of_DS,statistics=pool -
We are using the following:
db driver: jtds-1.3.0.jar
We are using j2EE 6. We are using a connection pool has the following configuration:
max-pool-size=50
flush-strategy="FailingConnectionOnly"
idle-timeout-minutes =3
- Do you know if it is possible capture this metric on JMX?
- Provide a way to obtain the datasource PeakInUseCount metric in JMX / JBOSS?
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.3.x and above
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
