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 OCTOBER 19, 2023
Applies to:
Oracle SOA Suite - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
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".
STEPS
-----------------------
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |