Skip to content

PreparedStatement.setTimestamp(index, timestamp, calendar) has datatype conversion issues. #443

@gs-rezaem

Description

@gs-rezaem

Driver version or jar name

The test works correctly with the old version of driver (2.0.1803), but fails with 4.x and 6.x, including 6.2.1 and 6.3 preview.

SQL Server version

Microsoft SQL Server 2008 (SP4) - 10.0.6241.0 (X64)

Client operating system

Windows 7

Java/JVM version

Oracle JDK 1.8.0_xxx

Table schema

See the test code Stand alone test class

Problem description

See the test code here: Stand alone test class

Expected behavior and actual behavior

When the query is executed with a prepared statement, it should return the correct result.

Repro code

Stand alone test class
This test code works correctly with MSSQL/2.0 driver, MSSQL/jtds driver, 4 other commercial and 3 open source databases. It fails with 4.x and 6.x series drivers.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions