Using oracle thin and OCI driver in transactions fails
moisesjboss Jul 6, 2006 5:28 PMI jave 2 jboss servers, each configured with jbossts. An ejb client calls bean1 in server1 and bean2 in server2 within a transaction. The beans do simple database inserts. Server1 uses oracle thin driver, and server2 uses oracle OCI driver (both 10g), and the combination fails...
If I use thin driver in both servers then there is no errors. Is it a requirement not mix drivers in transactions?
Error from server2 using OCI driver:
2006-07-06 14:06:42,467 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.resources.jts.orbspecific.xaerror] [com.arjuna.ats.internal.jta.resources.jts.orbspecific.xaerror] XAResourceRecord.rollback caused an XA error: XAException.XAER_RMERR
2006-07-06 14:06:42,482 WARN [jacorb.poa.controller] rid: 10 opname: _is_a cannot process request, because object doesn't exist
2006-07-06 14:06:42,482 WARN [jacorb.poa.controller] rid: 10 opname: _is_a request rejected with exception:
2006-07-06 14:06:42,498 WARN [jacorb.poa.controller] rid: 8 opname: rollback cannot process request, because object doesn't exist
2006-07-06 14:06:42,498 WARN [jacorb.poa.controller] rid: 8 opname: rollback request rejected with exception:
And this is the error in server1. The client bean is also running in server1:
14:06:03,910 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_36] - BasicAction.End() - prepare phase of action-id a68017a:fde:44ad67ce:226 failed.
14:06:03,910 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_38] - Action Aborting
14:06:03,942 ERROR [LogInterceptor] TransactionRolledbackException in method: public abstract void com.abc.txsample1.TxFacadeSession.doWork(com.abc.txsample1.TxSample1VO) throws java.rmi.RemoteException,com.abc.txsample1.ApplicationException, causedBy:
javax.transaction.RollbackException
at com.arjuna.ats.internal.jta.transaction.jts.TransactionImple.commit(TransactionImple.java:261)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:501)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
14:06:03,942 ERROR [STDERR] org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is:
javax.transaction.RollbackException; - nested throwable: (javax.transaction.RollbackException)
14:06:03,942 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.throwJBossException(TxInterceptorCMT.java:569)
14:06:03,942 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:506)
14:06:03,942 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
14:06:03,942 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
14:06:03,942 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)