Early technical preview of JDBC Driver 10.1.0 for SQL Server released

Published Dec 21 2021 01:30 PM 1,012 Views
Senior Member

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.

 

Encrypt = true, by default

 

There is one major breaking change in the 10.1 preview over previous releases. Similar to the HTTP to HTTPS default changes made in web browsers a few years back (and the security reasons for them), we are changing the default value of the `Encrypt` connection option from `false` to `true`. With the increased emphasis on secure-by-default, the growing use of cloud databases, and the need to ensure connections are secure, it's time for this backwards-compatibility-breaking change. We realize this will cause some disruption, but letting clients try to connect without encryption by default leaves them open to attack from malicious actors.

 

The action item if you are affected by the Encrypt change is to either (in order of recommendation):

  • Install a trusted certificate on your server.
  • Change your client's Encrypt connection string setting to false.

If you maintain an application that uses the Microsoft JDBC Driver for SQL Server and you don't expose the Encrypt setting to your users, it's recommended that you make application changes to allow users to opt-in to non-encrypted connections.

 

To learn more encrypting connections, see the SQL Server documentation on enabling encrypted connections to the database.


Below is a summary of the new additions and changes.


Added

  • Fix for Idle Connection Resiliency with Azure AD Authentication 1706
  • Retry for intermittent Java NativeSeedGenerator 1705
  • Default encryption to true 1697
  • Fix for Azure AD Interactive authentication timeout 1696

Changed

  • Deprecated AADSecurePrincipalId/AADSecurePrincipalSecret 1693

Fixed

  • Fixed TDSParser stuck on TDS_COLMETADATA issue [#1662] (#1662)
  • Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy [#1640] (#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>10.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:
‎Dec 21 2021 01:25 PM
Updated by: