Early technical preview of JDBC Driver 12.3.1 for SQL Server released

[Guest DavidEngelMS]

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.

 

 

 

Below is a summary of the changes in 12.3.1 over version 12.3.0.

 

 

 

Added

 

• Added a case to throw XAER_RMFAIL on connection reset for XA transactions 2118
  
• Added support for Azure Active Directory Service Principal Certificate Authentication 2128
  

Changed

 

• Improved performance of building parameter type definitions 1938
  
• Removed condition check that had no effect 2129
  
• Updated azure-security-keyvault-keys, azure-identity, gson and h2 dependency versions 2133
  
• Changed serverName sent in LOGIN packet to include instanceName 2140
  

Fixed issues

 

• Resolved high thread count when using findSocketUsingThreading 2104
  
• Corrected Activity ID behavior to stay the same for the life of the process, always send Activity ID in PRELOGIN, increment sequence for each new connection and send a unique client ID that persists for duration of process 2136
  

 

 

 

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 for Java 8 or .jre11 for Java 11 and up).

 

 

 

 

 

<dependency>

<groupId>com.microsoft.sqlserver</groupId>

<artifactId>mssql-jdbc</artifactId>

<version>12.3.1.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

 

Continue reading...