Performance difference in prepared statements compared to Open Source jTDS due to BigDecimal

[dospencer]

Driver version

SQL Server version

Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 18 2021 19:01:34 Copyright (C) 2019 Microsoft Corporation

Client Operating System

Windows

JAVA/JVM version

java version "11.0.9" 2020-10-20 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.9+7-LTS)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.9+7-LTS, mixed mode)

Table schema

Problem description

1. Expected behaviour: Insert of 85K records in less than 1 minute.
2. Actual behaviour: I encountered a performance issue with the MS JDBC driver. It takes about 39 minutes to insert 85K records into a MS SQL Server table using the MS SQL Server driver. If I use the Open Source JTDS driver then it takes only 39 seconds. The issue is only occurring when I have fields defined as BigDecimal in the application and that generates setBigDecimal for the prepared statement. If I change the data type from BigDecimal to Int, Float or Double, I do not get that performance issue.
3. Error message/stack trace:
4. Any other details that can be helpful:

JDBC trace logs

Reproduction code

[lilgreenbird]

hi @dospencer
Could you please provide the schema and the code to repro the issue?
Thanks

[Jeffery-Wasty]

This issue has been inactive for almost 4 weeks, so we'll go ahead and close. @dospencer, if the issue persists, let us know, and we can re-open the issue.

[vwarchu]

@Jeffery-Wasty We should determine if this is A) Reproducible as a generic case, and B) Related or duplicate of issue #1489

[tkyc]

Hi @dospencer, could you provide more details to your issue? eg. table schema, queries used, code, driver version. If possible a small simple repro app would be a big help as I was unable to repro the problem on my end. Thanks.

[tkyc]

Closing as it's been inactive, feel to re-open as necessary.