microsoft/mssql-jdbc

Computed columns and BULK INSERTs

chaks7 opened this issue · 2 comments

chaks7 commented

mssql-jdbc/src/main/java/com/microsoft/sqlserver/jdbc/SQLServerBulkCopy.java

Line 1737 in eae6d7b

"sp_executesql N'SET FMTONLY ON SELECT * FROM " + escapedDestinationTableName + " '");

Can the driver exclude computed columns? If a table has computed column in the definition I cannot import the data.

Jeffery-Wasty commented

Hi @chaks7,

What version of the driver are you using? We had an enhancement recently to ignore computed columns for batch insert merged in our 12.5 release. You can use the 12.6.1 stable release if you're interested in this enhancement.

chaks7 commented

Hi @Jeffery-Wasty: Yes, realized it is now fixed in 12.6.1. I was on the older version: 11.2.3.jre11. Closing the issue.