java bulkcopy快入插入数据_sqlserver java SQLServerBulkCopy 插入自增列

SQLServerBulkCopy

设置通过设置列映射来实现，只insert映射的列，不映射自增列，就可以自动插入自增列

确保 copyOptions.setKeepIdentity(true);

copyOptions.setKeepIdentity(true);

copyOptions.setBatchSize(2000);

copyOptions.setBulkCopyTimeout(5000);

// this is importance setting

copyOptions.setCheckConstraints(true);

bulkCopy.setBulkCopyOptions(copyOptions);

SQLServerBulkCSVFileRecord fileRecord = new SQLServerBulkCSVFileRecord(

FileFullPath, "GBK", "\r\n", false);

// Set the metadata for each column to be copied.

fileRecord.addColumnMetadata(1, "rowdata", java.sql.Types.NVARCHAR, 2000, 0);

bulkCopy.addColumnMapping("rowdata", "rowdata");

0.00 avg. rating (0% score) - 0 votes