Announcing the JDBC Driver 7.2 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 7.2 for SQL Server!

The 7.2 Release To World (RTW) includes the following items since the previous RTW release:

Added

  • Added APIs for DataSourceFactory and OSGI Framework #700
  • Added support for OffsetDateTime to be passed as 'type' in ResultSet.getObject() #830
  • Added support for Active Directory MSI Authentication #838
  • Added new APIs to retrieve SQL Server error information received with SQLServerException #905
  • Added a new SQLServerMetaData constructor for string values of length greater than 4000 #876
  • Added support for JDK 11 #824 #837 #807
  • Updated SQL keywords in DatabaseMetaData #829
  • Improvements in DatabaseMetadata to prevent Statement leaks and enhance Statement caching #806
  • Added streaming capabilities for Clob.getAsciiStream() #799

Fixed Issues

  • Fixed issue with ThreadPoolExecutor thread preventing JVM from exiting #944
  • Fixed Timestamp comparison with "Thai" locale in DataTypesTest #941
  • Fixed issue with java.time.OffsetDateTime value sent to the server being affected by the default timezone #831
  • Fixed SSL certificate validation to respect wildcards #836
  • Fixed Bulk Copy for batch insert operation to not error out against specific datatypes #912
  • Fixed an issue with Geography.point() having coordinates reversed #853
  • Fixed an issue with setAutoCommit() leaving a transaction open when running against Azure SQL Data Warehouse #881
  • Fixed potential NullPointerException in logException() #844
  • Fixed useBulkCopyForBatchInserts API to respect Statement timeout value #817
  • Fixed a bug where calling length() after obtaining a stream would close the stream for Clobs/NClobs #799
  • Fixed Clob/NClob encoding issues #799
  • Fixed issues in Bulk Copy exception handling #801
  • Fixed issues with apostrophe being passed in table name #780
  • Fixed statement leaks and improved exception handling in SQLServerParameterMetadata #780

Changed

  • Changed timeout request handling implementation to use SharedTimer #920
  • Fixed synchronization on a non-final field #860
  • Changed query timeout logic to use a single thread #842
  • Removed populating Lobs when calling ResultSet.wasNull() #875
  • Improved retry logic for intermittent TLS1.2 issue when establishing a connection #882
  • Removed illegal reflection access in Kerberos Authentication #839
  • Updated Clobs to use StandardCharsets.US_ASCII instead of hard-coded string #855
  • Changed error message to be thrown when data out of range for DECIMAL/NUMERIC types #796

Getting the latest release

The latest bits are available on the Microsoft Download Center, GitHub repository and Maven Central.

Add the JDBC 7.2 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 or .jre11 for your required Java version).

 <dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>7.2.0.jre11</version>
</dependency>

Help us improve the JDBC Driver by taking our surveyfiling issues on GitHub or contributing to the project.

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

David Engel