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
Fixed
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.
David Engel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.