Connection Pool statistics look low and database shows more than expected connections
Issue
- JDBC connection leak
- apps are closing connections properly still lot of inactive session at DB side
- causing slow performance and eventually bringing down the application and DB
- Datasource statistics
ActiveCountis dramatically different from the open connections as reported by the database server - The datasource pool has
prefillenabled
Environment
- Red Hat JBoss Enterprise Application Platform prior to 6.4.5
prefill=trueas defined injboss-as-datasources_1_1.xsdjboss-as-datasources_1_2.xsd
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
