Hi, Have you checked the .jca source to make sure this value is indeed checked? Sometimes even when you check this option in the wizard it doesn't reflect in the source when you also perform a select operation: http://docs.oracle.com/cd/E12839_01/relnotes.1111/e10133/adapter.htm. Also are you using the xADataSource driver in the data source and the xADataSourceName ConnectionFactory property?
18.104.22.168 The Value Of the Active Unit Of Work Property Is Not Saved for Outbound SELECT Operation
While configuring an outbound Oracle Database Adapter to perform a SELECT operation, if you select Get Active Unit of Work in the Adapter Configuration Wizard - Advanced Option page, then the value of the
GetActiveUnitofWorkproperty is not saved in the
The workaround for this issue is to manually add this property in the
.jcafile of the Oracle Database Adapter, as shown in the following example:
<property name="GetActiveUnitOfWork" value="true"/>
It is setup for XA Transactions and I am using the correct name. Also, I do have that property in my .jca file and it is for a pure sql update not a select. Should I maybe add this property to the config plan?
What I ended up doing is placing a dehydration activity + checking GetActiveUnitOfWork.