Schema Runtime Environment (SRE) 5.0.5 Update 1 Java Oracle eWay Adapter (XA) Fails to Connect to Oracle Database Version 11.2.0.2.0. - javax.transaction.xa.XAException (Doc ID 1360501.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Sun Schema Runtime Environment (SRE) - Version 5.0.5u1 and later
Information in this document applies to any platform.
Checked for relevance on 05-Sep-2014

Symptoms

When the Java Oracle eWay Adapter attempts to connect to an Oracle 11.2.0.2.0 database using XA, the following errors occur:

01:50:23.835 CDB I 4884 (java_extensions.cxx:1442): Session.open(): Opening database session...
01:50:24.192 CDB T 4884 (java_extensions.cxx:1442): Session.connect(): Established a XA Pooled Connection as User rms01user
01:50:24.197 CDB T 4884 (java_extensions.cxx:1442): Session.connect(): Got physical Connection
01:50:24.327 CDB T 4884 (java_extensions.cxx:1442): Session.connect(): Created connection verification Statement
01:50:24.330 CDB I 4884 (java_extensions.cxx:1442): Session.setDBMS(): Driver name is Oracle JDBC driver (ver: 10.2.0.1.0)
01:50:24.331 CDB I 4884 (java_extensions.cxx:1442): Session.setDBMS(): iDBMS = 1
01:50:24.337 CDB I 4884 (java_extensions.cxx:1442): Session.open(): Successfully opened database session
01:50:24.338 CDB I 4884 (java_extensions.cxx:1442): DbConnector.open(): Successfully opened Database connector
01:50:24.345 CDB I 4884 (java_extensions.cxx:1442): DbConnector.open(): 'cpToAndFromRMS:etdDBConn' was successfully registered with XA Coordinator
01:50:24.346 COL T 4884 (java_extensions.cxx:1442): JCollaboration (newInstance): Created com.retek.rib.etd.DBConn No. of ETDs = 1
01:50:24.369 COL T 4884 (java_extensions.cxx:1442): JCollaboration (newInstance): Created com.retek.rib.sbyn.etd.RibMessages No. of ETDs = 2
1:50:29.093 CDB T 4884 (java_extensions.cxx:1442): SqlObjectGroup.xaOpen() is called, xaErrorFlag = false
01:50:29.094 COL T 4884 (java_extensions.cxx:1442): XA Transaction Manager: ewItemsFromRMS/colItemsFromRMS{01F9642E-5A3B-11E0-B099-BD39C6CC40BB}: attempting to recover: cpToAndFromRMS:etdDBConn
01:50:29.109 CDB T 4884 (java_extensions.cxx:1442): xaErrorFlag = true
01:50:29.112 COLV T 4884 (initialize.cxx:278): JCS: Check if an exception occurred calling Java Collaboration translate ...
01:50:29.113 COL I 4884 (initialize.cxx:302): JCS: Java collaboration translate threw a com.stc.common.collabService.CollabConnException!
01:50:29.114 COL I 4884 (java_extensions.cxx:1442): *************** Exception occurred **************
01:50:29.115 COL I 4884 (java_extensions.cxx:1442): toString: com.stc.common.collabService.CollabConnException: [colItemsFromRMS] JCCollabControllerImpl JCCollabControllerImpl::translate(): Error in executing translate method
01:50:29.116 COL I 4884 (java_extensions.cxx:1442):
01:50:29.117 COL I 4884 (java_extensions.cxx:1442): getMessage: [colItemsFromRMS] JCCollabControllerImpl JCCollabControllerImpl::translate(): Error in executing translate method
01:50:29.118 COL I 4884 (java_extensions.cxx:1442):
01:50:29.120 COL I 4884 (java_extensions.cxx:1442): StackTrace:
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:525)
at com.stc.eways.jdbcx.SqlObjectGroup$MyXAResource.recover(SqlObjectGroup.java:372)
at com.stc.common.collabService.LoglessTC.recover(LoglessTC.java:968)
at com.stc.common.collabService.JXACoordinator.start(JXACoordinator.java:175)
at com.stc.common.collabService.JTransactionManagerImpl.xaStart(JTransactionManagerImpl.java:171)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:522)
com.stc.common.collabService.CollabConnException: null: XAER_RMERR
at com.stc.common.collabService.JXACoordinator.raise(JXACoordinator.java:43)
at com.stc.common.collabService.JXACoordinator.start(JXACoordinator.java:205)
at com.stc.common.collabService.JTransactionManagerImpl.xaStart(JTransactionManagerImpl.java:171)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:522)
com.stc.common.collabService.CollabConnException: [colItemsFromRMS] JCCollabControllerImpl JCCollabControllerImpl::translate(): Error in executing translate method
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:651)



The issue can be reproduced at will with the following steps:

1. Create a schema that uses the Oracle eWay Adapter to connect to Oracle 11.2.0.2.0 where the DataSource.class property in the Oracle eWay Connection Configuration is set to oracle.jdbc.xa.client.OracleXADataSource.
2. Run the schema.
3. The connection to Oracle should fail with the above errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms