Frequently JDBC connection dropout and slowness in acquiring new connections
Issue
-
User is suspecting that the connections are released too often from the JDBC connection pool. User wanted to enable debug in production to get low level audit. Just wanted to know what load it would add to the JVM and what is the recommended approach.
-
User has the current DataSource settings as below:
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<min-pool-size>25</min-pool-size>
<max-pool-size>50</max-pool-size>
<!-- Validataion Parameters -->
<background-validation>true</background-validation>
<background-validation-millis>120000</background-validation-millis>
<validate-on-match>true</validate-on-match>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MSSQLValidConnectionChecker</valid-connection-checker-class-name>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.NullExceptionSorter</exception-sorter-class-name>
<idle-timeout-minutes>12</idle-timeout-minutes>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>sqlserver</type-mapping>
</metadata>
- As this is a production instance user is experiencing slowness in acquiring new connections and the users is experiencing slow application performance.
- User is not seeing any error in the logs, user suspect that there is a frequent connection drop-out. How to enable JDBC debug level log?
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 5.1.0
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.
