3 Replies Latest reply on Jul 28, 2015 2:09 PM by Ravi D

    DB2 Connection Issue

    Ravi D Newbie

      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

        • 1. Re: DB2 Connection Issue
          Jesper Pedersen Master

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

           

          HTH

          • 2. Re: DB2 Connection Issue
            Ravi D Newbie

            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

            • 3. Re: DB2 Connection Issue
              Ravi D Newbie

              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>