DB2 Connection Issue

[ravi.d]

Hi All,

I am facing the issue in JBoss EAP 6.1.0 GA. Can anyone of you please advise how to resolve it.

04:59:23,229 WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: JTS XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMFAIL: com.ibm.db2.jcc.am.XaException: [jcc][10401][12067][3.64.82] XA exception: XAER_RMFAIL : [jcc][10335][11527][3.64.82] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 : [jcc][4025][11528][3.64.82] Exception from native code during XA. ERRORCODE=0, SQLSTATE=null ERRORCODE=-4228, SQLSTATE=null

        at com.ibm.db2.jcc.am.bd.c(bd.java:456)

        at com.ibm.db2.jcc.am.bd.c(bd.java:480)

        at com.ibm.db2.jcc.uw.UWXAResource.a(UWXAResource.java:624)

        at com.ibm.db2.jcc.uw.UWXAResource.b(UWXAResource.java:634)

        at com.ibm.db2.jcc.uw.UWXAResource.recover(UWXAResource.java:332)

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:358)

        at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.recover(XAResourceWrapperImpl.java:165)

        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:695) [jbossjts-jacorb-4.17.4.Final-redhat-2.jar:4.17.4.Final-redhat-2]

        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:419) [jbossjts-jacorb-4.17.4.Final-redhat-2.jar:4.17.4.Final-redhat-2]

        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:194) [jbossjts-jacorb-4.17.4.Final-redhat-2.jar:4.17.4.Final-redhat-2]

        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [jbossjts-jacorb-4.17.4.Final-redhat-2.jar:4.17.4.Final-redhat-2]

        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [jbossjts-jacorb-4.17.4.Final-redhat-2.jar:4.17.4.Final-redhat-2]

Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][10335][11527][3.64.82] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003

        at com.ibm.db2.jcc.am.bd.a(bd.java:669)

        at com.ibm.db2.jcc.am.bd.a(bd.java:60)

        at com.ibm.db2.jcc.am.bd.a(bd.java:120)

        at com.ibm.db2.jcc.uw.UWXAResource.b(UWXAResource.java:632)

        ... 8 more

Thanks

Ravi

[jesper.pedersen]

Seems like you are missing <validation>. But also, upgrade your installation.

HTH

[ravi.d]

Hi Jesper, Thanks for your reply. Could you please throw more light on upgrading installation. We are using driver version 4 to connect to DB2

[ravi.d]

Here is the setting:-

<xa-pool>

                        <min-pool-size>5</min-pool-size>

                        <max-pool-size>1000</max-pool-size>

                        <prefill>true</prefill>

                        <use-strict-min>false</use-strict-min>

                        <flush-strategy>IdleConnections</flush-strategy>

                        <is-same-rm-override>false</is-same-rm-override>

                        <pad-xid>false</pad-xid>

                        <wrap-xa-resource>true</wrap-xa-resource>

<recovery>

                        <recover-plugin class-name="org.jboss.jca.core.recovery.ConfigurableRecoveryPlugin">

                            <config-property name="EnableIsValid">

                                true

                            </config-property>

                            <config-property name="IsValidOverride">

                                false

                            </config-property>

                            <config-property name="EnableClose">

                                true

                            </config-property>

                        </recover-plugin>

                    </recovery>

                    <validation>

                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker"/>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>false</background-validation>

                        <use-fast-fail>false</use-fast-fail>

                        <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2StaleConnectionChecker"/>

                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ExceptionSorter"/>

  </validation>

                    <timeout>

                        <idle-timeout-minutes>1</idle-timeout-minutes>

                    </timeout>

                    <statement>

                        <track-statements>true</track-statements>

                    </statement>

                </xa-datasource>