My Oracle Support Banner

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

Last updated on JULY 10, 2020

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


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

01:50:23.835 CDB I 4884 (java_extensions.cxx:1442): 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:
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): Successfully opened database session
01:50:24.338 CDB I 4884 (java_extensions.cxx:1442): Successfully opened Database connector
01:50:24.345 CDB I 4884 (java_extensions.cxx:1442): '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!
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: [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:
at oracle.jdbc.xa.OracleXAResource.recover(
at null: XAER_RMERR
at [colItemsFromRMS] JCCollabControllerImpl JCCollabControllerImpl::translate(): Error in executing translate method

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 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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.