Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JCA Connection Issue

user9340864Sep 13 2012 — edited Oct 10 2012

Hi All

We are connecting a legacy database (Oracle DB) in a SOA process.
Sometimes the transaction succeeds but frequently we face below error and connection is not established.

Non Recoverable System Fault :

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 303 seconds BEA1-67A7063B6633DB2276DB at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1616) at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1503) at weblogic.jdbc.jta.DataSource.getConnection

This issue occurs intermittently.

Thanks
Ravdeep

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2012

Added on Sep 13 2012

#soa-process-management, #soa-suite-discusssions

10 comments

2,779 views