Why DataSource connection pool statistics values are not correct (always equal zero) in EAP 6

Solution Verified - Updated -

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? Since EAP 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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.