My Oracle Support Banner

SOA 11g: Error 'ORA-02049: timeout : distributed transaction waiting for lock' Using DB Adapter (Doc ID 1469506.1)

Last updated on MAY 01, 2018

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


Current weblogic connection pool configurations:
Both DB Adapter connections are "oracle.jdbc.xa.client.OracleXADataSource" and connecting to RAC
When attempting to insert rows into two separate tables related with a foreign key with two different adapters
the following error occurs.

"ORA-02049: timeout : distributed transaction waiting for lock."

1. Service 1 (DatabaseAdapter 1)-->inserting into table1
2. Service 1-->calls service 2 through WSDL
3. Service 2 (DatabaseAdapter 2)--> updating table 2 (Important: table 2 has foreign key to table1, If foreign key dropped then error resolved)



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.