Atomikos Forum

Error while using Atomikos with Oracle (11g)

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)
Prabath Abeysekara Send private email
Wednesday, March 13, 2013
 
 
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.
Prabath Abeysekara Send private email
Friday, March 15, 2013
 
 
Hi,

This should have been fixed in our 3.7.3 release - available to support customers only for now...
Guy Pardon Send private email
Saturday, March 30, 2013
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics