Early technical preview of JDBC Driver 11.1.1 for SQL Server released

Published Apr 22 2022 10:34 AM 1,161 Views
Senior Member

We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes.

 

Precompiled binaries are available on GitHub and also on Maven Central.

 

Encrypt = strict

There is one breaking change in the 11.1 preview over version 10.x. To support the new TDS 8.0 protocol where TLS encryption is negotiated before TDS, a new Encrypt option has been added, "strict". This required changing the getEncrypt() API to return a string instead of just a Boolean. Setting Encrypt to "strict" causes the driver to negotiate a TLS connection to the server first, instead of previous behavior where TDS was negotiated, then, if using encryption, TLS would be negotiated inside the TDS stream. Negotiating TLS first means all TDS connection and feature negotiation happens over an encrypted channel.

 

Below is a summary of the changes in 11.1.1 over version 11.1.0.

 

Added

  • Added support for Java 18 1802
  • Added support for bulk insert of null GUID values 1778
  • Added ALPN for TDS 8.0 connections 1795

Changed

  • Updated dependency versions of azure-keyvault and azure-identity 1798
  • Refactored Idle Connection Resiliency timeout to use existing SharedTimer 1794

Fixed issues

  • Fixed regression with Always Encrypted with secure enclaves 1805

 

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, .jre17, or .jre18 for your required Java version).

 

 

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>11.1.0.jre17</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

Co-Authors
Version history
Last update:
‎Apr 22 2022 10:34 AM
Updated by:
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE