DSL Batch Insert does not work with flag useBulkCopyForBatchInsert on SQL Server

[david-terk]

Batch insertion will not work if flag useBulkCopyForBatchInsert=true is set on SQL Server.

1. Create a table with a non auto incrementing primary key.
2. Ensure that the types meet the requirements of the Bulk Copy API see here. Ensure at least one type has a non nullable field.
3. Setup DSL and perform a batch insert.

Transaction will fail with message that column cannot be null. Set useBulkCopyForBatchInsert=false and repeat. There will be no issue.

[bog-walk]

@david-terk I was able to reproduce the exception and this seems to be a known problem with the mssql-jdbc driver and column order (differs between create and insert statement).

This has been fixed now and running tests (with your above specs) using at least version 12.3.0.jre8-preview resolved the exception on my end.

Please consider updating your SQL Server driver dependency and checking that it works for you too.