Transaction Timeouts in Oracle SOA Suite SCA Applications

The Problem Link to heading

I am currently working with Oracle SOA Suite 11.1.1.6 on WebLogic 10.3.6 and ran into a problem with a deployed SCA application that retrieves data from a web service and merges the results in a table using a DbAdapter to an Oracle database data source.

However, if the service took more than 30 seconds to complete (typically when most of the result set already existed in the database during the merge) then the service would timeout (see below).

The Solution Link to heading

The reason for this is the default WebLogic JTA timeout, which is set to 30 seconds. You can adjust it in the WebLogic console: Home -> JTA -> Timeout Seconds. In my case 120 seconds did the trick.

Originally published at https://jensenmo.blogspot.com/2013/01/transaction-timeouts-in-oracle-soa.html