My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.