OracleXARecovery transaction recovery module can not detect when JDBC connection is broken

[dengyong]

My environment:

JBOSS TS 4.2.3 SP6

My case is like below:

I am using com.arjuna.ats.internal.jdbc.recovery.OracleXARecovery recovery module to recovery my oracle XA resource in-doubt transaction.

Everything works fine until my network cable is unplugged. After the network is broken, I find following boring log is continually printed.

     

19:16:20,760 WARN  [loggerI18N] [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery  got XA exception javax.transaction.xa.XAException, XAException.XAER_RMERR

 

I studied the source code and did some investigations. I found the code can never detect when JDBC connection is broken underneath.

But we found JBOSS JCA JDBC pool can detect the bad connection. It is using org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker to validate the bad connection. I am not sure if OracleXARecovery can reuse this piece of code.

 

At last my question is:

• Is this bug fixed in later JBOSS JTA release?

[adinn]

This is the wrong place to ask this question as it is nothing to do with the design of JBoss Transactions. Questions about how to configure recovery should be posted to the User Forum. I notice that you have also posted this question there. Please do not waste the time of the developers by repeating your question here. Although the developers read both forums they are far less likely to respond to people who ask questions via the wrong channel or send the same question several times.

[mmusgrov]

And it also appears to be a cross post since the same question was asked in the user formum: http://community.jboss.org/message/546030#546030

[dengyong]

Thanks for the reminder. I will obey the rule next time.

[dengyong]

See the other thread on discussing this issue:

https://community.jboss.org/message/546146#546146