SOA 11g: DBAdapter Failing to use the Non-XA Data Source for SELECTs

(Doc ID 1470454.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

On : 11.1.1.5.0 version, Technology Adapters

ACTUAL BEHAVIOR
---------------
Two scenarios for a connection factory

1. configured a db adapter to use only dataSourceName, where the transaction initialization take 0 ms
2. configured a db adapter to use both dataSourceName and xADataSourceName, where the transaction initialization takes 157 ms

EXPECTED BEHAVIOR
-----------------------
No delay in the read operation for the 2nd scenario

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