Early technical preview of JDBC 6.1.7 for SQL Server released!

  • Article

We are delighted to release another early technical preview of the JDBC Driver for SQL Server. The focus of this preview release was adding constrained delegation support, adding new tests, and fixing issues identified by the community. Precompiled binaries are available on GitHub and also on Maven Central.

Below is a summary of the new additions to the project, changes made, and issues fixed.

Added

  • Added support for data type LONGVARCHAR, LONGNVARCHAR, LONGVARBINARY and SQLXML in TVP #259
  • Added new connection property to accept custom JAAS configuration for Kerberos #254
  • Added support for server cursor with TVP #234
  • Experimental Feature: Added new connection property to support network timeout #253
  • Added support to authenticate Kerberos with principal and password #163
  • Added temporal types to BulkCopyCSVTestInput.csv #262
  • Added automatic detection of REALM in SPN needed for Cross Domain authentication #40

Changed

  • Updated minor semantics #232
  • Cleaned up Azure Active Directory (AAD) Authentication methods #256
  • Updated permission check before setting network timeout #255

Fixed Issues

  • Turn TNIR (TransparentNetworkIPResolution) off for Azure Active Directory (AAD) Authentication and changed TNIR multipliers  #240
  • Wrapped ClassCastException in BulkCopy with SQLServerException #260
  • Initialized the XA transaction manager for each XAResource #257
  • Fixed BigDecimal scale rounding issue in BulkCopy #230
  • Fixed the invalid exception thrown when stored procedure does not exist is used with TVP #265

Getting the Preview Refresh
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.

 <dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>6.1.7.jre8-preview</version>
</dependency>

We provide limited support while in preview. Should you run into any issues, please file an issue on our GitHub Issues page.

As always, we welcome contributions of any kind. We appreciate everyone who has taken the time to contribute to the project thus far. For feature requests, please file an issue on the GitHub Issues page to help us track and follow-up directly.

We would also appreciate if you could take this survey to help us continue to improve the JDBC Driver.

Please also check out our tutorials to get started with developing apps in your programming language of choice and SQL Server.

Andrea Lam (andrela@microsoft.com)