JDBC Driver 12.8 for SQL Server Released

Version 12.8 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.8.0 brings several added features, changes, and fixed issues over the previous production release.

Added

• Java 22 support
• Credential caching when using Managed Identity Credential or Default Azure Credential
• Caching of the SQLServerBulkCopy object when using bulkcopy for batch insert
• Connection level caching for destination column metadata in bulkcopy
• SQL Server message handler and support for SQLException chaining
• Full support for RFC4180 for CSV bulk insert operations
• Direct construction of a microsoft.sql.DateTimeOffset instance from a java.time.OffsetDateTime value

Changed

• Enum SQLServerSortOrder is now public
• Removed synchronized from Socket overrides
• Revised previous RMERR/RMFAIL changes by making the default RMFAIL
• Updated dependencies
• Enhanced support for TDSType.GUID

Fixed issues

• 19 bug fixes detailed in the release notes

Getting the latest release

The latest bits are available to download from Microsoft, from the GitHub repository, and via Maven Central.

Add the JDBC 12.8 RTW 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/1.8 or .jre11 for Java 11 and up).

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>12.8.0.jre11</version> 
</dependency> 

Help us improve the JDBC Driver by filing issues on GitHub or contributing to the project.