Driver version

9.4.1, 10.2.0

SQL Server version

Microsoft SQL Server 2016 (SP2-CU15) (KB4577775) - 13.0.5850.14 (x64)
Sep 17 2020 22:12:45
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: )

Client Operating System

Windows 10

JAVA/JVM version

1.8.0

Table schema

CTEATE TABLE test (u_id UNIQUEIDENTIFIER);
INSERT INTO test(u_id) VALUES (?);

Problem description

Unable to insert NULL value into UNIQUEIDENTIFIER column in bulk insert mode (;useBulkCopyForBatchInsert=true), neither with setString(1,null), nor with setNull(1, VARCHAR).

Expected behavior

record inserted into table

Actual behavior

Exception is thrown

Error message/stack trace

Data type guid is not supported in bulk copy.