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