14 Replies Latest reply on Jan 8, 2008 2:45 PM by Mark Little

    DB2 XA in doubt state not recovered

    Jianming Yu Newbie

      Hello,

      I am using Jboss Two Phase commit by setup XA data source for DB2 (version 9) and Oracle database (9i) in our application. But the issue is when the transaction fails in the middle, I check the DB2 database the transaction is still in doubt state. Jboss did not rollback the in-doubt transaction automatically. Would you please give me a help to setup the Jboss 4.2.1 to rollback those indoubt transaction when fail over automatically?

      Thanks,

      Best regards,

      James

      <xa-datasource>
      <jndi-name>sm</jndi-name>
      <xa-datasource-class>
      com.ibm.db2.jcc.DB2XADataSource
      </xa-datasource-class>
      <xa-datasource-property name="DatabaseName">
      sm1
      </xa-datasource-property>
      <xa-datasource-property name="User">
      user
      </xa-datasource-property>
      <xa-datasource-property name="Password">
      password
      </xa-datasource-property>
      <min-pool-size>10</min-pool-size>
      <max-pool-size>100</max-pool-size>

      <type-mapping>DB2</type-mapping>

      </xa-datasource>