This content has been marked as final.
Show 4 replies
-
1. Re: Transaction Recovery -- XAResource + AppServerJDBCXAReco
jhalliday Nov 24, 2009 4:42 AM (in response to jelevy01)Are you sure the resources in question belong to mysql? If so a) have you configured the nodeid/recoverynodes? and b) are you aware there are significant limitations in mysql's XA implementation that will prevent it working in certain use cases?
-
2. Re: Transaction Recovery -- XAResource + AppServerJDBCXAReco
jelevy01 Nov 24, 2009 11:23 AM (in response to jelevy01)The exceptions that proceed the non-recoverable message are transaction failures, so no, I'm not positive they come from mysql / the datasource. Is there a better way to tell?
a) have you configured the nodeid/recoverynodes?
I have the following configured in jbossjta-properties.xml:<property name="com.arjuna.ats.arjuna.recovery.recoveryExtension1" value="com.arjuna.ats.internal.arjuna.recovery.AtomicActionRecoveryModule"/> <property name="com.arjuna.ats.arjuna.recovery.recoveryExtension2" value="com.arjuna.ats.internal.txoj.recovery.TORecoveryModule"/> <property name="com.arjuna.ats.arjuna.recovery.recoveryExtension3" value="com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule"/> ... <property name="com.arjuna.ats.arjuna.xa.nodeIdentifier" value="1"/> ... <property name="com.arjuna.ats.jta.recovery.XAResourceRecoveryJDBC" value="org.rhq.jbossatx.jta.recovery.AppServerJDBCXARecovery;MySqlDS"/> <property name="com.arjuna.ats.jta.xaRecoveryNode" value="1"/>
Is there more that I should have?b) are you aware there are significant limitations in mysql's XA implementation that will prevent it working in certain use cases?
I have read over:
http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html
I'm not clear on if that should effect recovery however.
Thanks.
Jeremy -
3. Re: Transaction Recovery -- XAResource + AppServerJDBCXAReco
vickyk Dec 1, 2009 5:47 AM (in response to jelevy01)<property name="com.arjuna.ats.jta.recovery.XAResourceRecoveryJDBC" value="org.rhq.jbossatx.jta.recovery.AppServerJDBCXARecovery;MySqlDS"/>
I am confused to see the above configuration, check in this how to set the recovery plugin
http://anonsvn.jboss.org/repos/labs/labs/jbosstm/trunk/atsintegration/classes/com/arjuna/ats/internal/jbossatx/jta/AppServerJDBCXARecovery.java
It should be like this<property name="com.arjuna.ats.jta.recovery.XAResourceRecovery1" value= "com.arjuna.ats.internal.jbossatx.jta.AppServerJDBCXARecovery;jndiname=MyExampleDbName"/>
Where does "org.rhq.jbossatx.jta.recovery.AppServerJDBCXARecovery" come from ? -
4. Re: Transaction Recovery -- XAResource + AppServerJDBCXAReco
jelevy01 Dec 1, 2009 2:10 PM (in response to jelevy01)It's just the package name, the XAResourceRecoveryJDBC isn't included with JBoss 4.2.2 so depending on where you get it from just put in whatever package you want.