Warn message "Destroying connection that could not be successfully matched" from DB2 JDBC datasource in JBoss EAP
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
