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

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