Warn message "Destroying connection that could not be successfully matched" from DB2 JDBC datasource in JBoss EAP

Solution Unverified - Updated -

Issue

It seems our production application is losing it's DB connection to DB2.  The connection will only come back after we restart JBoss. We are using this datasource:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><datasources>
    <local-tx-datasource>
        <jndi-name>testDB</jndi-name>
        <rar-name>jboss-local-jdbc.rar</rar-name>
        <use-java-context>true</use-java-context>
        <connection-definition>javax.sql.DataSource</connection-definition>
        <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name>
        <min-pool-size>1</min-pool-size>
        <max-pool-size>100</max-pool-size>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <blocking-timeout-millis>30000</blocking-timeout-millis>
        <idle-timeout-minutes>30</idle-timeout-minutes>
        <prefill>false</prefill>
        <background-validation>false</background-validation>
        <background-validation-millis>0</background-validation-millis>
        <validate-on-match>true</validate-on-match>
        <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter>
        <isSameRM-override-value>false</isSameRM-override-value>
        <allocation-retry>0</allocation-retry>
        <allocation-retry-wait-millis>5000</allocation-retry-wait-millis>
        <application-managed-security xsi:type="securityMetaData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <metadata/>
        <type-mapping>DB2</type-mapping>
        <local-transaction/>
        <user-name>***********</user-name>
        <password>***********</password>
        <check-valid-connection-sql>SELECT COUNT(TYPESCHEMA) FROM SYSCAT.DATATYPES</check-valid-connection-sql>
        <prepared-statement-cache-size>100</prepared-statement-cache-size>
        <share-prepared-statements>false</share-prepared-statements>
        <set-tx-query-timeout>false</set-tx-query-timeout>
        <query-timeout>0</query-timeout>
        <url-delimiter>|</url-delimiter>
        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
        <connection-url>jdbc:db2://10.20.30.40:50014/testDB</connection-url>
    </local-tx-datasource>
</datasources>

Environment

  • JBoss Enterprise Application Platform (EAP) 5
  • DB2

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.