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.
Idle Connection Resiliency
The biggest new feature in the release is Idle Connection Resiliency. This feature can transparently reconnect sessions that get disconnected due to network or server idle timeouts. This feature relies on TCP keepalives to detect when sockets are disconnected. On Java 11+ and Linux/macOS, the driver can configure keepalives automatically. However on Windows or on Java 8, there is no Java support for configuring the required keepalive settings. On those platforms, keepalives need to be manually configured in the OS in order to take advantage of this feature. For instructions on how to configure keepalives, see the existing documentation on avoiding Dropped Connections.
Below is a summary of the new additions and changes.
Added
- Idle Connection Resiliency Feature 1669
- Support for multi user scenarios for Always Encrypted key store providers 1614
- 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
