We have released a new early technical preview of the JDBC Driver for SQL Server. 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 NTLM Authentication #998
- Added new connection property 'useFmtOnly' to retrieve parameter metadata #1044
- Added support for JDK 12 with an additional "jre12" JAR #1050
- Added 'keyVaultProviderClientId' and 'keyVaultProviderClientKey' connection properties to enhance Always Encrypted usability #902
- Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1025
- Added Maven Shade plugin configuration to package the driver jars in uber-jars #1043 #1078 #1081
Fixed Issues
- Fixed DatabaseMetadata.getColumns() API to return ResultSet as per JDBC 4.3 Specifications #1016
- Fixed issue with invalid Spatial data types by marking them valid by default #1035
- Fixed issues with Login Timeout not getting applied appropriately #1049
- Fixed SharedTimer implementation to use class level lock for thread safety #1046
- Fixed issues with SQLServerDatabaseMetadata.getMaxConnections() API query #1009
- Fixed issues with next ResultSet being consumed when reading warnings #991
- Fixed exception handling in SQLServerPreparedStatement to make it consistent with SQLServerStatement#1003
- Fixed misleading exception message in SQLServerCallableStatement implementation #1064
- JUnit Test fixes and improvements #994 #1004 #1005 #1006 #1008 #1015 #1017 #1019 #1027 #1032#1034 #1036 #1041 #1047 #1060
Changed
- Improved performance of driver by continuously cleaning up ActivityIds stored in internal Map #1020
- Improved performance by removing Enum.values() calls to avoid unnecessary array cloning #1065
- Improved performance of SQLServerDataTable.internalAddRow() function #990
Getting the Preview
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.
Java 8:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>7.3.1.jre8-preview</version>
</dependency>Java 11:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>7.3.1.jre11-preview</version>
</dependency>Java 12:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>7.3.1.jre12-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.
David Engel
