Early technical preview of JDBC 6.1.6 for SQL Server released!

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 here and also on Maven Central.

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

Added

  • Added constrained delegation to connection sample #188
  • Added snapshot to identify nightly/dev builds #221
  • Clarifying public deprecated constructors in LOBs #226
  • Added OSGI Headers in MANIFEST.MF #218
  • Added cause to SQLServerException #202

Changed

  • Removed java.io.Serializable interface from SQLServerConnectionPoolProxy #201
  • Refactored DROP TABLE and DROP PROCEDURE calls in test code #222
  • Removed obsolete methods from DriverJDBCVersion #187

Fixed Issues

  • Typos in SQLServerConnectionPoolProxy #189
  • Fixed issue where exceptions are thrown if comments are in a SQL string #157
  • Fixed test failures on pre-2016 servers #215
  • Fixed SQLServerExceptions that are wrapped by another SQLServerException #213
  • Fixed a stream isClosed error on LOBs test #233
  • LOBs are fully materialized #16
  • Fix precision issue in TVP #217
  • Re-interrupt the current thread in order to restore the threads interrupt status #196
  • Re-use parameter metadata when using Always Encrypted #195
  • Improved performance for PreparedStatements through minimized server round-trips  #166

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.6.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 fill in this survey to help us learn more about how you think we should prioritize our work.

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)