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
