Refreshing table in SQL Server Using DbAdapter: Failed to create the XA control connection. Error: "The connection is closed."
(Doc ID 2833785.1)
Last updated on JANUARY 19, 2022
Applies to:Oracle SOA Suite - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When attempting to refresh a table in the MS SQL Server database using the DbAdapter, the transaction cannot be committed due to the following error. The data source being used in WebLogic is "Microsoft XA type 4 driver".
The issue can be reproduced at will with the following steps:
1. Create a Datasource in weblogic using "Microsoft XA type 4 driver".
2. Created a DbAdapter.
3. Use the DbAdapter in the SOA composite to run the delete and insert operations in a single transaction.
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