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.

[HEADING=2]Added[/HEADING]

• Java 22 support
  
• Credential caching when using Managed Identity Credential or Default Azure Credential
  
• Caching of the [iCODE]SQLServerBulkCopy[/iCODE] 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 [iCODE]microsoft.sql.DateTimeOffset[/iCODE] instance from a [iCODE]java.time.OffsetDateTime[/iCODE] value
  

Changed

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

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.

David Engel

Continue reading...