We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes.
Precompiled binaries are available on GitHub and also on Maven Central.
Below is a summary of the changes in 12.3.0 over version 12.2.0.
Added
- Added Java 20 support 2097
- Added access token callback class connection string property 2073
- Added additional logging to help debug authentication and encryption issues 2118
- Added SQL query to toString() in SQLServerPreparedStatement to support Hibernate JPA slow query logging 2099
Changed
- Updated azure-identity version 2114
- Updated msal4j version 2102
- Allow failover partner to be tried in case of socket timeout 2100
- Updated supportsLikeEscapeClause() to check for Azure data warehouse 2092
- sp_cursor calls now have table names passed in instead of an empty string 2087
- Updated federated authentication logic to use persistence token cache when fetching token 2079
- Updated supportTransaction method to reflect whether server supports transactions 2075
- Made jdk.net optional OSGi import 2069
- Upgraded to latest OSGi JDBC specification 2017
Fixed
- Fixed missing property value for disableStatmentPooling meta info query 2120
- Fixed typo in access token error message 2119
- Fixed BigDecimal error when values between 0 and 1 are specified 2116
- Fixed lockTimeout not taking effect when redirect mode is set in Azure DB 2110
- Fixed shared timer race condition 2085
- Fixed XA error handling to rethrow XAER_RMFAIL instead of XAER_RMERR 2078
- Fixed issue by accounting for zero meta query results 2074
- Fixed invalid batch inserts when columns provided in insert differs in order from table schema 1992
Getting the latest release
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 (choose .jre8 for Java 8 or .jre11 for Java 11 and up).
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>12.3.0.jre11</version>
</dependency>
Help us improve the JDBC Driver by taking our survey, filing 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