SQLServerException return a null SQLState when trying to convert a date to a long datatype

[ReneSvendsen]

Driver version

12.2

SQL Server version

SQL Server 2017 - 14.0.2042.3 (x64)

Client Operating System

Provide the Operating System the client application is running on.

JAVA/JVM version

1.8.0.272

Problem description

When trying to convert a column read from a recordset using getLong() and the column being converted is a string date-representation the following (expected) error message is shown:

The conversion from datetime to BIGINT is unsupported.

However the SQLState is reported as 'null'

Expected behavior

When the exception is thrown the SQLState '22005' was expected.

Actual behavior

SQLState is reported as 'null'

When using the jtds driver the SQLState is reported correctly.

[tkyc]

Thanks for letting us know. I'll need to attempt a repro to confirm this. I'll come back to this later and let you know as I'm in the middle of performing release tasks.

[lilgreenbird]

hi @ReneSvendsen

It would help if you could include the code and schema you used to repro this issue?

Thanks.

[lilgreenbird]

hi @ReneSvendsen

are you able to provide us with a repro of the issue?

[tkyc]

There's still more places in the driver where we are throwing null for the SQL state code. I'm marking this as an enhancement as we'll need to eventually resolve those as well.