If you are using the direct SQL deployment feature of the Oracle Commerce Platform and your database software is Microsoft SQL Server, add the following elements to the data source configuration files for each Oracle Commerce Platform server.
<new-connection-sql>SET XACT_ABORT ON</new-connection-sql>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
See information about the direct SQL deployment feature in the Content Administration Programming Guide.
