If you are using the direct SQL deployment feature of Oracle ATG Web Commerce and your database software is Microsoft SQL Server, add the following elements to the data source configuration files for each Oracle ATG Web Commerce 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 ATG Content Administration Programming Guide.
