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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content