Atomikos Forum |
|
Hi,
I am trying to use Atomikos distributed transaction manager with Oracle (11g), but, was confronted with an issue when issuing transactional statements within the global transaction. In this particular scenario, there are three tables in three different Oracle schemas associated with the branches of the global transaction. However, when the aforementioned transaction is executed, I am getting the following error [1] upon which I couldn't figure out any solution yet. Is there any known issues couldn't find any in the "known issues" section) with using Atomikos with Oracle spanning across different schemas within the same transaction? (Greatly appreciate any assistance on getting this sorted. Cheers, Prabath [1] java.lang.IllegalStateException: The given XAResource instance is being enlisted a second time without delist in between? at com.atomikos.icatch.jta.TransactionImp.enlistResource(TransactionImp.java:357) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
This issue exists with Both Oralce 10g as well. While going through the list of known issues, I found the MySQL parameter "pinGlobalTxToPhysicalConnection" is used to avoid a similar sort of a problem reported on MySQL. Does a similar property available for Oracle as well?
Appreciate any input on this. |