We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes.
Precompiled binaries are available on GitHub and also on Maven Central.
Below is a summary of the new additions and changes.
Added
- Idle Connection Resiliency Feature 1669
- Fix for Bulkcopy multi byte characters in char/varchar columns 1671
- Java 17 support 1676
- Added logging when deriving realm 1672
- Added check for closed statement to registerColumnEncryptionKeyStoreProvidersOnStatement 1644
- Added 42108 and 42109 to transient error list 1643
Fixed
- Fixed an issue where Statement.closeOnCompletion() would cause a Null Pointer Exception 1639
- Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy 1640
Getting the latest release
The latest bits are available on our GitHub repository, and Maven Central.
Add the JDBC preview driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project (choose .jre8, .jre11, or .jre17 for your required Java version).
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>9.5.0.jre11</version>
</dependency>
Help us improve the JDBC Driver by taking our survey, filing issues on GitHub or contributing to the project.
Please also check out our tutorials to get started with developing apps in your programming language of choice and SQL Server.
David Engel