We have released a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on https://github.com/Microsoft/mssql-jdbc/releases/tag/v7.3.0 and also on http://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22.
Below is a summary of the new additions to the project, changes made, and issues fixed.
Added
- Added support in SQLServerBulkCopy to allow Pooled/XA Connection instances during object creation https://github.com/Microsoft/mssql-jdbc/pull/968
- Added support for FLOAT data type for bulk copy operation when using RowSet https://github.com/Microsoft/mssql-jdbc/pull/986
Fixed Issues
- Fixed a possible Statement leak in SQLServerConnection.isValid() API https://github.com/Microsoft/mssql-jdbc/pull/955
- Fixed a rounding behavior when inserting datetime values into SQL Server version 2016 and later https://github.com/Microsoft/mssql-jdbc/pull/962
- Fixed SQLServerConnection.abort() API behavior to clear resources consistently https://github.com/Microsoft/mssql-jdbc/pull/983
- Fixed SQLServerConnection documentation https://github.com/Microsoft/mssql-jdbc/pull/984
- Fixed SQL Exception Error State length to respect SQLSTATE Standards https://github.com/Microsoft/mssql-jdbc/pull/977
Changed
- Refactored SELECT_METHOD in SQLServerConnection to not fetch the same connection property twice https://github.com/Microsoft/mssql-jdbc/pull/987
- Improved SQLServerParameterMetadata API implementations and code coverage https://github.com/Microsoft/mssql-jdbc/pull/973
Getting the Preview
The latest bits are available on our https://github.com/Microsoft/mssql-jdbc/releases/tag/v7.3.0 and http://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22.
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.
Java 8:
<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>7.3.0.jre8-preview</version> </dependency>
Java 11:
<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>7.3.0.jre11-preview</version> </dependency>
We provide limited support while in preview. Should you run into any issues, please file an issue on our https://github.com/Microsoft/mssql-jdbc/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 https://github.com/Microsoft/mssql-jdbc/issues page to help us track and follow-up directly.
We would also appreciate if you could take https://aka.ms/mssqljdbcsurvey to help us continue to improve the JDBC Driver.
Please also check out our http://aka.ms/sqldev to get started with developing apps in your programming language of choice and SQL Server.
David Engel