Release notes for the Microsoft JDBC Driver for SQL Server
This article lists the releases of the Microsoft JDBC Driver for SQL Server. For each release version, the changes are named and described.
12.8
Download Microsoft JDBC Driver 12.8.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.8.0 for SQL Server (tar.gz)
Release number: 12.8.0
Released: July 31, 2024
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
12.8 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 12.8. | • GitHub, 12.8.0 • Maven Central |
Fully compliant with JDBC API Specification 4.2. | The jars in the 12.8 package are named according to Java version compatibility. For example, the mssql-jdbc-12.8.0.jre11.jar file from the 12.8 package should be used with Java 11 (or higher). |
Compatible with Java Development Kit (JDK) version 22.0, 21.0, 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 12.8 for SQL Server is now compatible with Java Development Kit (JDK) version 22.0 in addition to JDK 21.0, 17.0, 11.0 and 1.8. |
12.8 Releases
Download Microsoft JDBC Driver 12.8.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.8.0 for SQL Server (tar.gz)
Release number: 12.8.0
Released: July 31, 2024
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 12.8
Feature | Details |
---|---|
Java 22 support | The driver is now compatible with Java Development Kit (JDK) version 22.0 in addition to JDK 21.0, 17.0, 11.0 and 1.8. |
Added credential caching when using Managed Identity Credential or Default Azure Credential | Allow caching of the mentioned credentials in order to improve performance and driver reliability. |
Allow caching of the SQLServerBulkCopy object when using bulkcopy for batch insert |
Replaces previous behavior, where each call of executeBatch() generated a new SQLServerBulkCopy object, by caching the object instead. |
Added connection level caching for destination column metadate in bulkcopy | Improves performance by adding caching at the connection level for destination column metadata in bulkcopy scenarios. This feature is enabled by setting the newly added connection string property cacheBulkCopyMetadata to true (default value is false ). |
Added a SQL Server message handler and support for SQLException chaining | Added a SQL Server message handler allowing for several features including additional feedback for long running queries, universal error logging, and automatic downgrade of error-message severity from SQLException to SQLWarning. Additionally, this feature allows for chaining of SQLExceptions together so that all error messages are available to the user. See Handling Errors. |
Provided full support for RFC4180 for CSV bulk insert operations | Support for quoted fields containing newlines were missing in order to ensure full support with RFC4180; this has been added. |
Allow constructing a microsoft.sql.DateTimeOffset instance from a java.time.OffsetDateTime value |
Conversion between the two data types already existed in the driver using a Timestamp intermediary. This addition removes that intermediary, improving performance and reducing the potential for timezone-related errors. |
Changes in 12.8
Change | Details |
---|---|
Enum SQLServerSortOrder is now public |
Changed visibility of the enum SQLServerSortOrder to public which allows users greater flexibility in queries that use this enum. |
Remove synchronized from Socket overrides |
Incorrectly added in prior changes to confirm with code check standards, the select methods changed do not, in fact, need to be synchronized, and have been changed to reflect this. |
Revised previous RMERR/RMFAIL changes by making the default RMFAIL |
Prior changes changed the value of XAER_RMFAIL to XAER_RMERR for select cases, however these cases quickly became a majority of all cases covered. The solution is to change the default to RMFAIL and convert to RMERR for inverse of previously stated cases. |
Updated dependencies | Updated dependency versions for azure-identity , bouncycastle , and msal . |
Revised support for TDSType.GUID |
Enhances the original addition of support for TDSType.GUID by allowing direct passage of the UUID to the setObject method. |
Added logging to token caching | Added additional logging for token caching scenarios to help in debug scenarios. |
Fixes in 12.8
Fix | Details |
---|---|
Fixed regression with specifying argument names in callable statement syntax | Fixed a regression from 12.6.2 --> 12.6.3 where CallableStatements of a certain format returned incorrect values. GitHub Issue #2477. |
Fixed parsing for parantheses in stored procedures and functions | Fixed an issue where calling a function with paranthesis at the end in a callable statement, e.g. function() vs function, resulting in the return value always being 0. This was a regression from 12.6.2 --> 12.6.3. GitHub Issue #2463. |
Fixed an error where CallableStatement with default arguments weren't being respected by the driver. |
Fixed an error that was a regression from 12.5.0 --> 12.6.0, where default arguments in callable statements were being ignored. GitHub Issue #2446. |
Fix to remove TokenCredential class where it's not required |
TokenCredentialClass isn't needed in SQLServerSecurityUtility and can cause an incorrectly thrown NoClassDefFoundError . This removes the import, replacing it with a generic Object . GitHub Issue #2439. |
Fixed timestamp string conversion error for CallableStatements | Fixed a conversion exception that occured when calling a DateTime in/out parameter while setting a String value. GitHub Issue #2436. |
Fixed SqlAuthenticationToken constructor to accept correct parameter | The constructor for SQLAuthenticationToken was incorrect, working with an input parameter in seconds, when it should have been milliseconds. GitHub Issue #2424. |
Fix to clear prepared statement handle before reconnection | This fixes an issue where the wrong handles were used in a SQLServerPreparedStatement after reconnection by properly clearing SQLServerPreparedStatement.prepStmtHandle before reconnecting. GitHub Issue #2364. |
Fix to clear prepared statement cache when resetting statement pool connection | This fixes an issue where, with statement pooling enabled, reusing a connection from a ConnectionPool resulted in missing, or incorrectly inserted, entries. GitHub Issue #2356. |
Fix to unbind socketTimeout from loginTimeout |
socketTimeout should have an upper-bound of loginTimeout for connection establishment, but should have no upper-bound after the driver has connected. This fixes that behavior. GitHub Issue #2354. |
Fix to properly check if TDSCommand counter is null before attempting to increment |
Adds a missing null check for the TDSCommand counter, preventing a NullPointerException that could otherwise arise. GitHub Issue #2353. |
Fix calling procedures with output parameters by their four-part syntax | Fixes an issue where calling stored procedures with a four-part syntax (i.e. with a linked server) resulted in an error stating the TDS protocol stream isn't valid. GitHub Issue #2344. |
Fix to properly escape schema parameteres for getProcedures and getProcedureColumns |
The SQLServerDatabaseMetadata methods getProcedures and getProcedureColumns weren't properly escaping certain characters (e.g. \ ) for the schema parameter. This fixes that issue. GitHub Issue #2336. |
Added token cache map to fix use of unintended auth token for subsequent connections | This fixes an issue where client credentials could be reused as, while the auth token is cached, it's reused with only the client secret changed. GitHub Issue #2334. |
Fixed support for exec escape syntax in CallableStatements |
This fixes an issue where, after removing the wrapped sp_executesql /sp_prepexec calls in order to execute CallableStatements quickly, EXEC calls were no longer working. GitHub Issue #2325. |
Fix to ensure Money and SmallMoney are within the correct ranges for BulkCopy |
This fixes an issue where, when using BulkCopy with Money or SmallMoney values, conversion to/from the values can cause an ArithmeticOverflowException . GitHub Issue #2309. |
Fix to ensure ResultSetMetadata for DataabseMetadata.getColumns() is correct for all columns |
The returned metadata was incorrect for some columns, this fixes that problem. GitHub Issue #2232. |
Fix to properly turn off connection retries when connectRetryCount is set to 0 |
This fixes the behavior where, even with connectRetryCount set to 0, the driver attempted to retry until loginTimeout was reached. GitHub Issue #2232. GitHub Issue #2188. |
Fix to address a ClassLoader leak of ActivityCorrelator ThreadLocal |
Fixes an issue where, after previous driver changes to ActivityId , ThreadLocal in ActivityCorrelator is never being removed from the thread. |
Fix to execute stored procedures directly for RPC calls | RPC calls were using prior logic by being wrapped in sp_executesql calls; this fixes that behavior. |
Previous releases
12.6
Download Microsoft JDBC Driver 12.6.3 for SQL Server (zip)
Download Microsoft JDBC Driver 12.6.3 for SQL Server (tar.gz)
Release number: 12.6.3
Released: June 20, 2024
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
12.6 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 12.6. | • GitHub, 12.6.0 • Maven Central |
Fully compliant with JDBC API Specification 4.2. | The jars in the 12.6 package are named according to Java version compatibility. For example, the mssql-jdbc-12.6.0.jre11.jar file from the 12.6 package should be used with Java 11 (or higher). |
Compatible with Java Development Kit (JDK) version 21.0, 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 12.6 for SQL Server is now compatible with Java Development Kit (JDK) version 21.0 in addition to JDK 17.0, 11.0 and 1.8. |
12.6 Releases
Release number: 12.6.3
Released: June 20, 2024
Fixed issues in 12.6.3:
- Fixed issue where TokenCredential class was required to be imported
- Fixed timestamp string conversion regression
- Fixed SQLServerCallableStatement default value regression
Download Microsoft JDBC Driver 12.6.3 for SQL Server (zip)
Download Microsoft JDBC Driver 12.6.3 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 12.6.2
Released: May 23, 2024
Added features in 12.6.2:
- Added credential caching for Managed Identity Credential and Default Azure Credential
Fixed issues in 12.6.2:
- Check that money and small money are within correct range for bulkcopy
- Check if TDSCommand counter is null before incrementing
- Clear prepared statement cache when resetting statement pool connection
- Clear prepared statement handle before reconnect
- RPC calls for CallableStatements will be executed directly
- Corrected authentication token object to accept expiration in milliseconds
- SocketTimeout should be unbounded by loginTimeout after a successful connection open
Download Microsoft JDBC Driver 12.6.2 for SQL Server (zip)
Download Microsoft JDBC Driver 12.6.2 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 12.6.1
Released: February 20, 2024
Fixed issues in 12.6.1:
- Fixed 'EXEC' escape syntax for CallableStatements
Download Microsoft JDBC Driver 12.6.1 for SQL Server (zip)
Download Microsoft JDBC Driver 12.6.1 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 12.6.0
Released: January 31, 2024
Download Microsoft JDBC Driver 12.6.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.6.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 12.6
Feature | Details |
---|---|
Java 21 support | The driver is now compatible with Java Development Kit (JDK) version 21.0 in addition to JDK 17.0, 11.0 and 1.8. |
Allow calling of stored procedures directly through use of new connection property useFlexibleCallableStatements |
The driver now call store procedures directly, as opposed to wrapping the procedure around exec sp_executesql , simplifying the procedure and improving performance. |
Added useDefaultJaasConfig connection string property |
When set to true, allows Kerberos authentication without additional external configuration. |
Added useDefaultGSSCredential connection string property |
When set to true, allows the driver to create GSSCredential on behalf of the user, when using Native GSS-API for Kerberos authentication. |
Added calcBigDecimalPrecision connection string property |
When set to true, allows the driver to calculate precision for BigDecimal inputs. |
Added new named loggers for connection open retries and idle connection resiliency reconnects | Connection open retries uses the Redirection logging category, and can be used at the FINE logging level. Idle connection resiliency reconnects uses the Resiliency logging category, and can be used at the FINE or FINER logging levels. |
Changes in 12.6
Change | Details |
---|---|
Changed how IBM JDK is checked for prevent issues with OSGi environments | Changed from only checking vendor name, to checking both vendor and vm name. |
Properly synchronized all calls to MSAL | Prevents the driver from making extra calls and proving unnecessary dialogues. |
Added additional errors that should translate to RMFAIL | Added additional cases, "connection reset by peer" and "connection timed out", that should equate to RMFAIL |
Changed how Timestamps are used in BulkCopy | Change BulkCopy behavior from serializing and deserializing Timestamp objects, to using the objects directly, leading to a performance improvement when using a large number of Timestamps. |
Changed socketTimeout to ensure it's properly less than loginTimeout |
Previously socketTimeout acted independetly from loginTimeout leading to potentially confusing behavior where the driver would take longer to timeout than expected. This has been fixed so socketTimeout always has an upper bound equal to loginTimeout . |
Adjusted PreparedStatement cache so it's cleared before every execute | The PreparedStatement cache wasn't being cleared correctly, which, in addition to its infrequency, could lead to memory issues over time. This change ensures the cache is cleaned before each execute, preventing object build-up. |
Upgraded to newer Bouncycastle dependencies | Upgrade from bcprov-jdk15on and bcpkix-jdk15on to bcprov-jdk18on and bcpkix-jdk18on as the former is no longer being updated. |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys , bouncycastle , h2 and msal . |
Fixes in 12.6
Fix | Details |
---|---|
Fixed a missing null check for e.getCause() | Fixed an issue where, when an exception has no cause, the exception itself is passed along instead, preventing it from being lost. GitHub Issue #2299. |
Fixed locks in IOBuffer to prevent deadlock issues that could arise | Fixed implementation of locks in IOBuffer, specifically around disableSSL, to prevent deadlocks that could arise in certain situations. GitHub Issue #2288. GitHub Issue #2265. |
Fixed an issue with Timestamps and bulk copy for batch insert | Fixed timezone not being properly applied to Timestamps when inserted using batch insert with bulkcopy. GitHub Issue #2271. |
Fixed missing getters and setters for useBulkCopyForBatchInsert |
Fixed an issue where behavior was not the same between SQLServerConnection and SQLServerConnnectionPoolProxy , when it should be, as useBulkCopyForBatchInsert was missing a getter and setter in the latter. GitHub Issue #2245. |
Fixed bulkcopy metadata query to make use of cached data, if available | Fixed an issue where, despite the data being cached, calls for column metadata were being called each time. GitHub Issue #2224. |
Fixed a missing BigDecimal scale check for TVP values | - Fixed an issue where, when writing TVP row values, input values were not properly filtered for BigDecimal scale. GitHub Issue #2222. |
Fixed schemaPattern in SQLServerDatabaseMetadata to ensure its properly escaped | Fixed an issue where schemaPattern was the only pattern not properly being escaped in SQLServerDatabaseMetadata. GitHub Issue #2186. |
Fixed an issue where a null SQLState was returned when trying to convert a date to a long | Fixed an issue where, when xopenStates is set to true, the driver does not return the expected SQL-99 state code in a particular instance. GitHub Issue #2167. |
Fixed getMetaData error for queries containing TOP | Fixed an issue where, when using the TOP qualifier in a query, the driver returns an error concerning ParameterMetadata. GitHub Issue #1776. |
Fixed a table name parsing issue when using batch inserts | Fixed an issue where insert statements with missing whitespace worked correctly in regular cases, but not when using batch inserts. GitHub Issue #1534. |
Fixed an issue with ParameterMetadata and invalid indexes | Fixed an issue with ParameterMetadata not properly checking, and throwing exceptions for, an invalid index 0. GitHub Issue #1490. |
Fixed behavior of ActivityID in ActivityCorrelator | Fixed the way ActivityID was defined and used to be more in line with the behavior of other Microsoft drivers. |
Fix to ignore computed columns when using bulkcopy for batch insert | Fixed BulkCopy behavior to ignore computed columns, and allow batch inserts, when previously the insert would fail and return an error citing those computed columns. |
Fixed driver behavior concerning signatures when using Java Key Store and Azure Key Vault | Fixed an issue where signature was not properly verfied when using Java Key Store, as well as adding a new API to sign column master key metadata (and return generated signature) for use with Java Key Store and Azure Key Vault |
Fixes getObject()'s erroneous conversion of DateTimeOffset | Fixed an issue when calling ResultSet.getObject() on a DATETIMEOFFSET column, with LocalDate/LocalTime/LocalDateTime as the class argument, the value in the column would be converted to the local time zone. |
12.4
Download Microsoft JDBC Driver 12.4.2 for SQL Server (zip)
Download Microsoft JDBC Driver 12.4.2 for SQL Server (tar.gz)
Release number: 12.4.2
Released: October 27, 2023
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
12.4 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 12.4. | • GitHub, 12.4.0. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 12.4 package are named according to Java version compatibility. For example, the mssql-jdbc-12.4.0.jre11.jar file from the 12.4 package should be used with Java 11 (or higher). |
Compatible with Java Development Kit (JDK) version 20.0, 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 12.4 for SQL Server is now compatible with Java Development Kit (JDK) version 20.0 in addition to JDK 17.0, 11.0 and 1.8. |
12.4 Releases
Release number: 12.4.2
Released: September 21, 2023
Fixed issues in 12.4.2:
- Reverted the IBM check to vendor check and added an additional vm name check to remove false positives
Download Microsoft JDBC Driver 12.4.2 for SQL Server (zip)
Download Microsoft JDBC Driver 12.4.2 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 12.4.1
Released: August 24, 2023
Changes in 12.4.1:
- Prepared SQL parameter names now have automatic spacing applied
Fixed issues in 12.4.1:
- Fixed metadata query getUserName in impersonated security context in Azure SQL database
- Fixed IBM JDK detection
- Fixed bug where signature isn't verified for Java Key Store and add signColumnMasterkeyMetadata API to JKS and AKV
- Added localization of error strings that was missing in original release
Download Microsoft JDBC Driver 12.4.1 for SQL Server (zip)
Download Microsoft JDBC Driver 12.4.1 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 12.4.0
Released: July 31, 2023
Download Microsoft JDBC Driver 12.4.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.4.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 12.4
Feature | Details |
---|---|
Java 20 support | The driver is now compatible with Java Development Kit (JDK) version 20.0 in addition to JDK 17.0, 11.0 and 1.8. |
Added access token callback connection string property | Supplements the previously implemented access token callback by allowing passing in the name of the callback-implementing class in the connection string. |
Added support for ActiveDirectoryServicePrincipalCertificate | Improvement to the user experience by supporting ActiveDirectoryServicePrincipalCertificate from the Azure Identity Library via the connection option authentication=ActiveDirectoryServicePrincipalCertificate . |
Added another case for XAER_RMFAIL | The driver was still returning XAException with error XAER_RMERR in some cases. An additional case was added to XA error handling to address this. |
Changes in 12.4
Change | Details |
---|---|
Updated federated authentication logic to use persistent token cache when fetching token | This update both improves performance in token fetch scenarios and more easily allows compatibility with future MSAL versions. |
Allow failover partner to be tried if there's a socket timeout | Allows a reconnection attempt with a supplied failover partner following a socket timeout. |
Improved performance when building parameter type definitions | By precomputing sizes of arrays and string builders used in buildParamTypeDefinitions , and by removing unneeded string allocations, improve performance where this method is used. |
Changed serverName sent in LOGIN packet to include instanceName |
serverName is now appended to the end of instanceName in LOGIN packets. |
Updated supportTransaction method to reflect whether server supports transactions | Addresses an issue where connection.rollback didn't work for Azure Synapse database, as the syntax used in supportTransaction wasn't supported by Azure Synapse. |
Update sp_cursor calls so that table names are passed in instead of an empty string | Addresses an issue where inconsistent updates of ResultSet rows were received when updating one-to-many tables. |
Updated supportsLikeEscapeClause() to check for Azure Data Warehouse | Addresses an issue where supportsLikeEscapeClause was returning true for AzureDW despite it explicitly not being supported. |
Upgraded to latest OSGi JDBC specification | Upgrade from osgi.compendium 5.0.0 to osgi.service.jdbc 1.1.0 to maintain compliance with OSGi JDBC specification 8.1.0. |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys , gson , h2 and msal . |
Fixes in 12.4
Fix | Details |
---|---|
Fixed performance and memory issues present with BigDecimal | Reverts all changes, since the 12.2 release, regarding BigDecimal. This fix addresses the performance issues that were observed. Users need to take care when using BigDecimal to avoid the truncation issues that were previously addressed. GitHub Issue #2176. |
Fixed server certificate validation for encrypt=strict | Fix to ensure the server certificate is properly validated in cases where encrypt is set to strict . GitHub Issue #2174. |
Fixed lockTimeout not taking effect when redirect mode is set in Azure DB | Fixed when lockTimeout is set, as it should only apply to connections from outside Azure, and not from within Azure, as was previously. GitHub Issue #2110. |
Fixed high thread count when using findSocketUsingThreading | Fixes an issue where an uncaught exception led to interruption in sleep calls upstream, causing retries to happen too quickly. GitHub Issue #2104. |
Fixed shared timer race condition | Fixed a potential race condition in the SharedTimer class. GitHub Issue #2085. |
Fixed an error with stored procedures and zero result metaQuery return |
Fixed an issue where, if metaQuery returned no result after execution of a stored procedure, this would return a parameter undefined error. GitHub Issue #2063. |
Fixed invalid batch inserts when columns provided in insert differs in order from table schema | Fixed an issue where usage of useBulkCopyForBatchInsert=true can lead to column mix-up and invalid data. GitHub Issue #1992. |
Fixed XA error handling to rethrow XAER_RMFAIL instead of XAER_RMERR | Fixed an issue where, the driver would return XAException with error code XAER_RMERR in case of failover of SQL Server from primary node to standby node while committing an XA Transaction. GitHub Issue #1432. |
Fixes to Activity ID and Client ID behavior to maintain consistency with JDBC specification | Fixed Activity ID behavior to stay the same for the life of the process, always send Activity ID in PRELOGIN , and increment sequence for each new connection. Also fixed client ID to persist for the life of the process. |
12.2
Download Microsoft JDBC Driver 12.2.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.2.0 for SQL Server (tar.gz)
Release number: 12.2.0
Released: January 31, 2023
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
12.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 12.2. | • GitHub, 12.2.0. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 12.2 package are named according to Java version compatibility. For example, the mssql-jdbc-12.2.0.jre11.jar file from the 12.2 package should be used with Java 11 (or higher). |
Compatible with Java Development Kit (JDK) version 19.0, 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 12.2 for SQL Server is now compatible with Java Development Kit (JDK) version 19.0 in addition to JDK 17.0, 11.0 and 1.8. |
12.2 Releases
Download Microsoft JDBC Driver 12.2.0 for SQL Server (zip)
Download Microsoft JDBC Driver 12.2.0 for SQL Server (tar.gz)
Release number: 12.2.0
Released: January 31, 2023
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 12.2
Feature | Details |
---|---|
Java 19 support | The driver is now compatible with Java Development Kit (JDK) version 19.0 in addition to JDK 17.0, 11.0 and 1.8. |
Added support for access token callback | Allows client code to register a callback on a DataSource that returns an access token. |
Added support for DefaultAzureCredential | Improvement to the user experience by supporting both DefaultAzureCredential and IntelliJCredential from the Azure Identity Library via the connection option authentication=ActiveDirectoryDefault . |
Added a new connection property datetimeParameterType to specify datatype to use for date/timestamp parameters | Added a connection property datetimeParameterType which allows users to explicitly specify conversions to datetime or datetime2 , providing greater compatibility in older databases. |
Changes in 12.2
Change | Details |
---|---|
Made driver Loom-friendly | Replaces synchronized(foo) with reentrant locks, improving performance when using Loom. |
Managed Identity authentication uses Azure Identity library | Replaces the driver's built-in code to obtain and cache Managed Identity tokens with the Azure Identity library. This change adds Managed Identity support for more Azure services over what the driver previously supported. |
Made MSAL an optional dependency | Made msal4j an optional dependency again. |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys , antlr4-runtime , bcprov-jdk15on , bcpkix-jdk15on , and msal . |
Update to dynamically check for ExtendedSocketOption class | Addresses an error where missing ExtendedSocketOptions was returning a NoClassDefFoundError . |
Fixes in 12.2
Fix | Details |
---|---|
Fixed null SQL state and zero error code when database exception is thrown | Fixed an issue where, after SQL Error, the SQL State and error code showed incorrect information. GitHub Issue #2015. |
Fixed Idle Connection recovery so that unprocessedResponseCount isn't over-decremented |
unprocessedResponseCount needs to only be decremented when doneToken.isFinal is true, it was being decremented regardless. GitHub Issue #1971. |
Fixed connecting to the wrong SQLServer host | Fixes a concurrency issue where, when a driver is connecting to multiple SQLServer hosts, a connection could be established to the wrong host. GitHub Issue #1964. |
Fixed incorrect updateCount |
The incorrect update count can happen in both true/false cases for enablePrepareOnFirstPreparedStatementCall and for both prepexec/prepare. GitHub Issue #1961. |
Fixed concurrency issues in encrypt/decrypt obfuscation methods for truststore password | Added locks to encrypt/decrypt in truststore password obfuscation. GitHub Issue #1939. |
Fixed cache account name casing issue | Fixes an issue where account names were sent to the Microsoft Authentication Library with case-sensitivity, leading to repeated login requests. GitHub Issue #1923. |
Fixed query cancellation bug | Fixed query cancellation bug that intermittently occurs in batch queries. GitHub Issue #1896. |
Fixed callable statement errors | Fixes callable statement "index out of bounds" and "parameter not defined" errors. GitHub Issue #1871. |
Fixed check for DONE token when fetching result sets | Adds a missed case to previous DONE_ERROR fix, where DONE_ERROR status from the server resulting from a killed session was ignored by the driver. GitHub Issue #1846. GitHub Issue #1505. |
Ensure that batchParamValues is cleared in all cases when executing a batch | Addresses an issues where batches weren't properly cleared on failure when using bulk update. GitHub Issue #1767. |
Fixed precision sent when using BigDecimal | Fixes an issue where, by default, BigDecimal values were sent with maximum precision, which could result in undesired decimal rounding. GitHub Issue #1489. GitHub Issue #942 |
Fixed attestation protocol NONE to work in all cases |
Fixed logic behind NONE attestation protocol to work in all cases, not just specific ones. |
Fixed race condition in SecureStringUtil | Fixed a race condition in SecureStringUtil during creation of SecureStringUtil. |
11.2
Download Microsoft JDBC Driver 11.2.3 for SQL Server (zip)
Download Microsoft JDBC Driver 11.2.3 for SQL Server (tar.gz)
Release number: 11.2.3
Released: January 12, 2023
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
11.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 11.2. | • GitHub, 11.2.0. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 11.2 package are named according to Java version compatibility. For example, the mssql-jdbc-11.20.jre17.jar file from the 11.2 package should be used with Java 17. |
Compatible with Java Development Kit (JDK) version 18.0, 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 11.2 for SQL Server is now compatible with Java Development Kit (JDK) version 18.0 in addition to JDK 17.0, 11.0 and 1.8. |
11.2 Releases
Release number: 11.2.3
Released: January 12, 2023
Fixed issues in 11.2.3:
- Fixed null SQL state and zero error code when database exception is thrown
- Fixed incorrect update counts when timeout occurs in batch queries
- Fixed incorrect token expiration date when using Azure Functions
- Fixed connecting to the wrong SQLServer host
Release number: 11.2.2
Released: December 15, 2022
Fixed issues in 11.2.2:
- Fixed Idle Connection Resiliency bug
- Clear prepared statement handle cache on idle reconnect
- Fixed callable statement index out of bounds error
- Fixed check for DONE token when fetching result sets
- Fixed intermittent error: "Internal error during decryption: Tag mismatch!"
Download Microsoft JDBC Driver 11.2.2 for SQL Server (zip)
Download Microsoft JDBC Driver 11.2.2 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 11.2.1
Released: September 8, 2022
Fixed issues in 11.2.1:
- Made
com.microsoft.azure:msal4j
an optional dependency - Fixed a query cancellation bug that intermittently occurred in batch queries
Download Microsoft JDBC Driver 11.2.1 for SQL Server (zip)
Download Microsoft JDBC Driver 11.2.1 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 11.2.0
Released: August 4, 2022
Download Microsoft JDBC Driver 11.2.0 for SQL Server (zip)
Download Microsoft JDBC Driver 11.2.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 11.2
Feature | Details |
---|---|
Java 18 support | The driver is now compatible with Java Development Kit (JDK) version 18.0 in addition to JDK 17.0, 11.0 and 1.8. |
Added Configurable IPv6 Support | The IP address preference for the client application can now be set between IPv4 and IPv6. Use the new ipaddresspreference connection setting to control the behavior. For more information, see Setting the connection properties. |
Added support for prepare method selection | Added new connection string property prepareMethod to toggle between use of sp_prepare and sp_prepexec. Use the new prepareMethod connection setting to control the behavior. For more information, see Setting the connection properties. |
Added serverCertificate connection property for encrypt=strict | Added a serverCertificate property that's the path to the server certificate file (in PEM format). Used for validation when using encrypt set to strict. For more information, see Setting the connection properties. |
Cache parameter metadata calls | Encryption-related information for parameterized queries can now be cached. See Using Always Encrypted with the JDBC driver. |
Added support for bulk insert of null GUID values | Resolves an issue where insertion of null values wasn't possible in bulk insert mode. |
Added support for caching managed identity tokens | Allow for caching of tokens obtained from managed identity endpoints. |
Changes in 11.2
Change | Details |
---|---|
TDS 8.0 support by adding "strict" option to encrypt connection property | BREAKING CHANGE Encrypt connection property is now of type string. |
Added check for negotiated ALPN | Checks to make sure to Application-Layer Protocol is successfully negotiated. |
Added an option for enclaveAttestationProtocol | Added option for NONE protocol so that secure enclaves can be used without attestation. |
Allow serverName to be reordered in connection string | Validate that the serverName field of the connection string doesn't have an equal sign. |
Added better error logging for missing MSAL library | Added an error message when MSAL is missing in the case of ActiveDirectoryServicePrincipal . |
Refactored Idle Connection Resiliency timeout to use existing SharedTimer | Improved efficiency with Idle Connection Resilency by using the existing SharedTimer. |
Send TDS version 8 in Login7 when in strict mode | Added additional information to Login7 packet by including TDS version 8 when encrypt=strict. |
Changed default loginTimeout value to 30s | Changed the default loginTimeout value from 15 seconds to 30 seconds to allow more time for initial connections to be resolved before timing out. |
msal4j dependency is now explicit |
Added an explicit dependency for msal4j (was a transitive dependency in previous releases). |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys . |
Fixes in 11.2
Fix | Details |
---|---|
Fixed error caused by preparedMethod=prepare | Fixed intermittent null prepared statement handle error caused by sp_prepare when used with batch queries GitHub Issue #1880. |
Fixed an error where establishing multiple connections in parallel can throw an IndexOutOfBoundsException | Fixed race condition with addressList, which may result in IndexOutOfBoundsException when establishing multiple connections GitHub Issue #1852. |
Fixed assertion fails happening when canceling "insert into" statement | Fixed an issue where the driver may assert when canceling a statement GitHub Issue #1849. |
Fixed an exception not being thrown as expected when the session is killed in SQL database | Added check for DONE_ERROR status token, which may occur from a killed session on the server GitHub Issue #1846. |
Managed Identity Retry interval | Fixed Managed Identity retry interval to properly back off exponentially GitHub Issue #1765. |
Removed an extra call to executeCommand() within connectionCommand() | Removed an extra call to executeCommand, that was causing performance issues for some users GitHub Issue #1669. |
Fixed unknown token error with selectMethod | Fixed unknown token error 0xA3 when selectMethod cursor is used with data classification. |
10.2
Download Microsoft JDBC Driver 10.2.3 for SQL Server (zip)
Download Microsoft JDBC Driver 10.2.3 for SQL Server (tar.gz)
Release number: 10.2.3
Released: January 12, 2023
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 10.2.2
Released: December 13, 2022
Download Microsoft JDBC Driver 10.2.2 for SQL Server (zip)
Download Microsoft JDBC Driver 10.2.2 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Release number: 10.2.1
Released: May 12, 2022
Download Microsoft JDBC Driver 10.2.1 for SQL Server (zip)
Download Microsoft JDBC Driver 10.2.1 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
10.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 10.2. | • GitHub, 10.2.0. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 10.2 package are named according to Java version compatibility. For example, the mssql-jdbc-10.20.jre17.jar file from the 10.2 package should be used with Java 17. |
Compatible with Java Development Kit (JDK) version 17.0, 11.0, and 1.8. | Microsoft JDBC Driver 10.2 for SQL Server is now compatible with Java Development Kit (JDK) version 17.0 in addition to JDK 11.0 and 1.8. |
10.2 Releases
Release number: 10.2.3
Released: January 12, 2023
Fixed issues in 10.2.3:
- Fixed incorrect update counts when timeout occurs in batch queries
- Fixed incorrect token expiration date when using Azure Functions
- Fixed null SQL state and zero error code when database exception is thrown
Release number: 10.2.2
Released: December 13, 2022
Fixed issues in 10.2.2:
- Clear prepared statement cache on idle connection resiliency reconnects
- Fix for setting KeepAlive extended options
- Fixed issue where the driver may assert when canceling a statement
- Fixed callable statement index out of bounds error
- Fixed issue not checking for DONE token errors so exceptions are ignored
- Fixed query cancellation bug
Release number: 10.2.1
Released: May 12, 2022
Fixed issues in 10.2.1:
- Changed Idle Connection Resiliency timeout to use existing SharedTimer
- Fixed Managed Identity authentication retry interval to exponentially back off properly
- Removed extraneous call to executeCommand() within connectionCommand()
Release number: 10.2.0
Released: January 31, 2022
Download Microsoft JDBC Driver 10.2.0 for SQL Server (zip)
Download Microsoft JDBC Driver 10.2.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 10.2
Feature | Details |
---|---|
Java 17 support | The driver is now compatible with Java Development Kit (JDK) version 17.0 in addition to JDK 11.0 and 1.8. |
Idle Connection Resiliency support | Idle Connection Resiliency is now supported. See Idle Connection Resiliency. |
Multi-user Key Store Providers | The driver now supports Key Store providers at the connection and statement level to support multi-user scenarios. See Using Always Encrypted with the JDBC driver. |
Changes in 10.2
Change | Details |
---|---|
Default encrypt to true | BREAKING CHANGE TLS encryption is enabled by default. |
Certificate validation when encrypt = false | BREAKING CHANGE When encrypt = false but the server requires encryption, the certificate is validated based on the trustServerCertificate connection setting. |
aadSecurePrincipalId and aadSecurePrincipalSecret deprecated | The aadSecurePrincipalId and aadSecurePrincipalSecret connection properties have been deprecated. Use username and password instead. |
getAADSecretPrincipalId API removed | BREAKING CHANGE The getAADSecretPrincipalId API has been removed for security reasons. |
SQL_Variant support | Added support for SQL_Variant datatype when retrieving DateTimeOffset. |
Nonblocking random in Linux | Updated to use a nonblocking random call when generating a GUID for enclave packages. |
CNAME resolution for realm | Added CNAME resolution when realm is specified. |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys , gson , and bouncycastle . |
Fixes in 10.2
Fix | Details |
---|---|
TDSParser stuck on TDS_COLMETADATA | Fixed: TDSParser stuck on TDS_COLMETADATA, which could result in a hang for certain queries. GitHub Issue #1661 |
9.4
Download Microsoft JDBC Driver 9.4.1 for SQL Server (zip)
Download Microsoft JDBC Driver 9.4.1 for SQL Server (tar.gz)
Release number: 9.4.1
Released: December 7, 2021
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
9.4 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 9.4. | • GitHub, 9.4.0. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 9.4 package are named according to Java version compatibility. For example, the mssql-jdbc-9.4.0.jre16.jar file from the 9.4 package should be used with Java 16. |
Compatible with Java Development Kit (JDK) version 16.0, 11.0, and 1.8. | Microsoft JDBC Driver 9.4 for SQL Server is now compatible with Java Development Kit (JDK) version 16.0 in addition to JDK 11.0 and 1.8. |
9.4 Releases
Version number: 9.4.1
Released: December 07, 2021
Fixed issues in 9.4.1:
- Fixed a potential hang when the driver encounters unsupported TDS_COLMETADATA
- Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy
Version number: 9.4.0
Released: July 30, 2021
Download Microsoft JDBC Driver 9.4.0 for SQL Server (zip)
Download Microsoft JDBC Driver 9.4.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
New features in 9.4
Feature | Details |
---|---|
Java 16 support | The driver is now compatible with Java Development Kit (JDK) version 16.0 in addition to JDK 11.0 and 1.8. |
Replication connection support | Replication connections are now supported. See Setting the connection properties. |
Custom Kerberos authentication realm | The driver now supports specifying a custom authentication realm when using Kerberos authentication. See Setting the connection properties. |
Open Connection Retry | The connectRetryCount and connectRetryInterval connection properties have been added to configure automatic retries when opening connections. See Setting the connection properties for details on these new properties. |
Changes in 9.4
Change | Details |
---|---|
Azure Key Vault Provider | Multiple, successive connections can be opened that specify different Azure Key Vault provider information. |
Updated error messages | Error messages related to Enclave exceptions now include a link to a troubleshooting guide. Error messages related to Active Directory authentication failures now include the error string from the underlying library. |
Driver version sent to server | The driver version is now correctly sent to the database during PRELOGIN . |
Client process ID | The client process ID is now sent to the server when running on Java 9+. Java 8 keeps the previous functionality of sending 0 for the client process ID. |
Updated dependencies | Updated dependency versions for azure-identity , azure-security-keyvault-keys , gson , antlr , and bouncycastle . |
Removed unnecessary references | Removed unused Java 9 specific class references from the Java 8 jar |
Fixes in 9.4
Fix | Details |
---|---|
GitHub Issue #1499 | Fixed: Batch fails when always encrypted is enabled in the connection string and clearParameters is called. |
GitHub Issue #1632 | Fixed: Small memory leak on new connection. |
GitHub Issue #1565 | Fixed an issue where trustStorePassword is null when using applicationIntent=ReadOnly |
GitHub Issue #1568 | Fixed an issue where redirected token contains named instance in servername |
GitHub Issue #1531 | Fixed potential integer overflow in TDSWriter.writeString() |
9.2
Download Microsoft JDBC Driver 9.2.1 for SQL Server (zip)
Download Microsoft JDBC Driver 9.2.1 for SQL Server (tar.gz)
Version number: 9.2.1
Released: March 02, 2021
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
9.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 9.2. | • GitHub, 9.2.1. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 9.2 package are named according to Java version compatibility. For example, the mssql-jdbc-9.2.1.jre15.jar file from the 9.2 package should be used with Java 15. |
Compatible with Java Development Kit (JDK) version 15.0, 11.0, and 1.8. | Microsoft JDBC Driver 9.2 for SQL Server is now compatible with Java Development Kit (JDK) version 15.0 in addition to JDK 11.0 and 1.8. |
9.2 Releases
Version number: 9.2.1
Released: March 02, 2021
Fixed issues in 9.2.1:
- Fixed an issue with client secret being empty during ActiveDirectoryServicePrincipal authentication in Azure environment.
Version number: 9.2.0
Released: January 29, 2021
Download Microsoft JDBC Driver 9.2.0 for SQL Server (zip)
Download Microsoft JDBC Driver 9.2.0 for SQL Server (tar.gz)
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Support for JDK 15
Microsoft JDBC Driver 9.2 for SQL Server is now compatible with Java Development Kit (JDK) version 15.0 in addition to JDK 11.0 and 1.8.
Added support for Azure Active Directory Interactive Authentication
Authentication type addition | Details |
---|---|
Microsoft JDBC Driver 9.2 for SQL Server now supports authentication to Azure Key Vault via interactive authentication. | See Connecting using Azure Active Directory authentication. |
Added support for Azure Active Directory Service Principal Authentication
Authentication type addition | Details |
---|---|
Microsoft JDBC Driver 9.2 for SQL Server now supports authentication to Azure Key Vault using the client ID and secret of a service principal identity. | See Connecting using Azure Active Directory authentication. |
Updated Azure Key Vault library to use modern Azure Key Vault library
Library changes for Azure Key Vault | Details |
---|---|
Microsoft JDBC Driver 9.2 migrated from the previous-generation Azure Key Vault library and ADAL libraries to the more modern Azure Key Vault and Azure Identity equivalents. |
DEPENDENCY CHANGE Make sure you update your application dependencies if you take advantage of Azure Active Directory authentication or Azure Key Vault. See the dependency requirements when work with the Azure Key Vault provider or Azure Active Directory authentication |
Enabled useBulkCopyForBatchInsert for non-Azure Synapse Analytics servers
useBulkCopyForBatchInsert changes for non Azure Synapse Analytics servers | Details |
---|---|
Microsoft JDBC Driver 9.2 now allows bulk copy API for batch insert operation against non-Azure Synapse Analytics servers. | See Using bulk copy API for batch insert operation. |
8.4
Download Microsoft JDBC Driver 8.4 for SQL Server (zip)
Download Microsoft JDBC Driver 8.4 for SQL Server (tar.gz)
Version number: 8.4.1
Released: August 27, 2020
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
8.4 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 8.4. | • GitHub, 8.4.1. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 8.4 package are named according to Java version compatibility. For example, the mssql-jdbc-8.4.1.jre14.jar file from the 8.4 package should be used with Java 14. |
Compatible with Java Development Kit (JDK) version 14.0, 11.0, and 1.8. | Microsoft JDBC Driver 8.4 for SQL Server is now compatible with Java Development Kit (JDK) version 14.0 in addition to JDK 11.0 and 1.8. |
8.4 Releases
Version number: 8.4.1
Released: August 27, 2020
Fixed issues:
- Fixed an issue with
SQLServerConnectionPoolProxy
not being compatible withdelayLoadingLobs
- Fixed a potential
NullPointerException
issue withdelayLoadingLobs
- Fixed an issue with decrypting column encryption keys when using the Windows Certificate Store
Version number: 8.4.0
Released: July 31, 2020
Support for JDK 14
Microsoft JDBC Driver 8.4 for SQL Server is now compatible with Java Development Kit (JDK) version 14.0 in addition to JDK 11.0 and 1.8.
Added support for authentication to Azure Key Vault using Managed Identity
Authentication type addition | Details |
---|---|
Microsoft JDBC Driver 8.4 for SQL Server now supports authentication to Azure Key Vault using Managed Identity. | See Using Always Encrypted with the JDBC driver. |
Extended support for bulk copy for Azure Data Warehouse
Bulk copy changes for Azure Data Warehouse | Details |
---|---|
Microsoft JDBC Driver 8.4 adds a new connection property, sendTemporalDataTypesAsStringForBulkCopy . This boolean property is TRUE by default. |
See Using bulk copy with the JDBC driver. |
Added support for Azure SQL DNS caching
DNS Caching | Details |
---|---|
Microsoft JDBC Driver 8.4 for SQL Server now supports DNS caching against SQL Server on Azure VMs. |
Added backwards compatibility for streaming LOB objects
LOB Streaming | Details |
---|---|
Microsoft JDBC Driver 8.4 for SQL Server added a new connection property delayLoadingLobs . |
Setting delayLoadingLobs to FALSE causes all LOB objects retrieved from the ResultSet to not be streamed. This setting means that the driver loads the entire LOB object into memory at once, similar to how the driver was functioning before version 6.4 release. |
Added support for client certificate authentication for loopback scenarios
Client certificate authentication | Details |
---|---|
Microsoft JDBC Driver 8.4 for SQL Server added a new authentication method called client certificate authentication for loopback scenarios. | See Client Certificate Authentication for Loopback Scenarios. |
8.2
Download Microsoft JDBC Driver 8.2 for SQL Server (zip)
Download Microsoft JDBC Driver 8.2 for SQL Server (tar.gz)
Version number: 8.2.2 Released: March 24, 2020
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a zip file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
8.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 8.2. | • GitHub, 8.2.2. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 8.2 package are named according to Java version compatibility. For example, the mssql-jdbc-8.2.2.jre11.jar file from the 8.2 package should be used with Java 11. |
Compatible with Java Development Kit (JDK) version 13.0, 11.0, and 1.8. | Microsoft JDBC Driver 8.2 for SQL Server is now compatible with Java Development Kit (JDK) version 13.0 in addition to JDK 11.0 and 1.8. |
8.2 Releases
Version number: 8.2.2
Released: March 24, 2020
Fixed issues:
- Added an option to configure the list of trusted Azure Key Vault endpoints
Version number: 8.2.1
Released: February 26, 2020
Fixed issues:
- Fixed a potential
NullPointerException
issue when retrieving data asjava.time.LocalTime
orjava.time.LocalDate
type withSQLServerResultSet.getObject()
Version number: 8.2.0
Released: January 31, 2020
Support for JDK 13
Microsoft JDBC Driver 8.2 for SQL Server is now compatible with Java Development Kit (JDK) version 13.0 in addition to JDK 11.0 and 1.8.
Always Encrypted with secure enclaves
Always Encrypted change | Details |
---|---|
Microsoft JDBC Driver 8.2 for SQL Server now supports Always Encrypted with secure enclaves. The details can be found here: Always Encrypted with secure enclaves. | |
More details and sample code. | See Always Encrypted with secure enclaves. |
Performance Improvement when Retrieving Temporal Datatypes from SQL Server 1
Temporal Datatypes change | Details |
---|---|
Microsoft JDBC Driver 8.2 for SQL Server has improved performance when retrieving temporal datatypes from SQL Server. | This change eliminates unnecessary temporal datatype conversions by eliminating the use of java.util.Calendar wherever possible. |
The following list of temporal data types are affected by this performance improvement; in the format "SQL Server datatype" (Java mapping). | date (java.sql.Date), datetime (java.sql.Timestamp), datetime2 (java.sql.Timestamp), smalldatetime (java.sql.Timestamp), and time (java.sql.Time). |
1 Due to the differences in how time zones are handled between java.util.Calendar and java.time.LocalDateTime API, temporal datatypes with a user provided java.util.Calendar object associated with it or microsoft.sql.DateTimeOffset datatypes don't benefit from this improvement.
Deployment of mssql-jdbc_auth-<version>-<arch>.dll (previously sqljdbc_auth.dll) to Maven Repository
sqljdbc_auth.dll change | Details |
---|---|
Starting with Microsoft JDBC Driver 8.2 for SQL Server, the driver relies on mssql-jdbc_auth-<version>-<arch>.dll instead of sqljdbc_auth.dll to use Azure Active Directory Authentication feature. | |
The DLL has also been uploaded to Maven repository for easier access. | See this page. |
8.2 Known issues
Known issues | Details |
---|---|
When using Always Encrypted with secure enclaves with Java 8. | Users must include BouncyCastle Provider as a dependency OR map/load a security provider, which supports the RSASSA-PSS signature algorithm. |
7.4.1
Download Microsoft JDBC Driver 7.4.1 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 7.4.1 for SQL Server (tar.gz)
Version number: 7.4.1
Released: August 2, 2019
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
7.4 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 7.4. | • GitHub, 7.4.1. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 7.4 package are named according to Java version compatibility. For example, the mssql-jdbc-7.4.1.jre11.jar file from the 7.4 package should be used with Java 11. |
Compatible with Java Development Kit (JDK) version 12.0, 11.0, and 1.8. | Microsoft JDBC Driver 7.4 for SQL Server is now compatible with Java Development Kit (JDK) version 12.0 in addition to JDK 11.0 and 1.8. |
7.4 Releases
Version number: 7.4.1
Released: August 2, 2019
Fixed issues:
- Reverted new
hashCode()
andequals()
API implementations fromSQLServerDataTable
andSQLServerDataColumn
as the API change broke backwards compatibility
Version number: 7.4.0
Released: July 31, 2019
Support for JDK 12
Microsoft JDBC Driver 7.4 for SQL Server is now compatible with Java Development Kit (JDK) version 12.0 in addition to JDK 11.0 and 1.8.
Introduces NTLM authentication
NTLM change | Details |
---|---|
Supports NTLM authentication mode. | This mode of authentication allows both Windows and non-Windows clients to authenticate themselves against SQL Server using Windows domain users. |
More details and a sample application to use this authentication mode. | See Connecting using NTLM Authentication. |
Introduces querying ParameterMetaData via useFmtOnly
useFmtOnly change | Details |
---|---|
useFmtOnly connection property added. | This feature allows users to optionally query ParameterMetaData via the SET FMTONLY ON legacy API. This setting is useful for scenarios where sp_describe_undeclared_parameters doesn't perform as expected. |
More details and limitations. | See Using useFmtOnly |
Updated Microsoft Azure Key Vault SDK for Java, version 1.2.1
Key Vault SDK change | Details |
---|---|
Updated its Maven dependency on Microsoft Azure Key Vault SDK for Java to version 1.2.1. | |
Removes Microsoft Azure SDK for Key Vault WebKey as a Maven dependency. | |
More details. | See Feature dependencies of the Microsoft JDBC Driver for SQL Server. |
7.4 Known issues
Known issues | Details |
---|---|
When using NTLM Authentication. | Enabling Extended Protection and encrypted connections at the same time is currently not supported. |
When using useFmtOnly. | There are some issues with the feature, which are caused by deficiencies in SQL parsing logic. For more information and workaround suggestions, see Using useFmtOnly. |
7.2.2
Download Microsoft JDBC Driver 7.2.2 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 7.2.2 for SQL Server (tar.gz)
Version number: 7.2.2
Released: April 16, 2019
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
7.2 Compliance
Compliance change | Details |
---|---|
Download the latest updates for JDBC Driver 7.2. | • GitHub, 7.2.2. • Maven Central. |
Fully compliant with JDBC API Specification 4.2. | The jars in the 7.2 package are named according to Java version compatibility. For example, the mssql-jdbc-7.2.2.jre11.jar file from the 7.2 package should be used with Java 11. |
Compatible with Java Development Kit (JDK) version 11.0 in addition to JDK 1.8. | Microsoft JDBC Driver 7.2 for SQL Server is now compatible with Java Development Kit (JDK) version 11.0 in addition to JDK 1.8. |
7.2 Releases
Version number: 7.2.2
Released: April 16, 2019
Fixed issues:
- Fixed issues with ActivityIDs not getting cleaned up properly
Version number: 7.2.1
Released: February 11, 2019
Fixed issues:
- Fixed parsing issues with certain parameterized queries
Version number: 7.2.0
Released: January 31, 2019
Active Directory Managed Identity (MSI) authentication
MSI change | Details |
---|---|
Supports Active Directory Managed Identity (MSI) authentication mode. | This mode of authentication is applicable on Azure Resources with support for the "Identity" feature enabled. Both types of Managed Identities (MSI) are supported by the driver to acquire accessToken for establishing secure connection. |
More details and a sample application to use this authentication mode. | See Connecting using Azure Active Directory Authentication. |
Introduces Open Service Gateway Initiative (OSGi) support
OSGi change | Details |
---|---|
DataSourceFactory implementation added. | • org.osgi.service.jdbc.DataSourceFactory • com.microsoft.sqlserver.jdbc.osgi.SQLServerDataSourceFactory |
Activator implementation added. | • org.osgi.framework.BundleActivator • com.microsoft.sqlserver.jdbc.osgi.Activator |
Introduces SQLServerError APIs
Error API change | Details |
---|---|
SQLServerError API introduced. | Getter APIs to retrieve more details about the error generated from the server. • SQLServerException.getSQLServerError() • SQLServerError |
More details. | See Handling Errors. |
Updated Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java, version 1.6.3
ADAL4J change | Details |
---|---|
Updated its Maven dependency on ADAL4J to version 1.6.3. | |
Introduces Java Client Runtime for AutoRest as a Maven dependency, version 1.6.5. | |
More details. | See Feature dependencies of the Microsoft JDBC Driver for SQL Server. |
Updated Microsoft Azure Key Vault SDK for Java, version 1.2.0
Key Vault SDK change | Details |
---|---|
Updated its Maven dependency on Microsoft Azure Key Vault SDK for Java to version 1.2.0. | |
Introduces Microsoft Azure SDK for Key Vault WebKey as a Maven dependency, version 1.2.0. | |
More details. | See Feature dependencies of the Microsoft JDBC Driver for SQL Server. |
7.2 Known issues
Known issues | Details |
---|---|
Parameterized queries, in certain cases. | An update of the 7.2.0 version, v7.2.1, was released in February 2019 to address this issue. |
Cleaning up of ActivityIds. | An update of the 7.2.1 version, v7.2.2, was released in April 2019 to address this issue. |
7.0
Download Microsoft JDBC Driver 7.0 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 7.0 for SQL Server (tar.gz)
Version number: 7.0.0
Released: July 31, 2018
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Microsoft JDBC Driver 7.0 for SQL Server is fully compliant with JDBC API Specification 4.2. The jars in the 7.0 package are named according to Java version compatibility. For example, the mssql-jdbc-7.0.0.jre10.jar file from the 7.0 package should be used with Java 10.
Support for JDK 10
Microsoft JDBC Driver 7.0 for SQL Server is now compatible with Java Development Kit (JDK) version 10.0 in addition to JDK 1.8. This update also exposes the driver's Automatic-Module-Name
as com.microsoft.sqlserver.jdbc
through its MANIFEST file.
Support for spatial datatypes
Microsoft JDBC Driver 7.0 for SQL Server now provides support for SQL Server spatial datatypes Geography and Geometry. For more information about spatial datatype APIs and how to use them, see Using spatial datatypes.
Implementation for JDBC 4.3 introduced java.sql.Connection APIs beginRequest() and endRequest()
Microsoft JDBC Driver 7.0 for SQL Server now implements beginRequest()
and endRequest()
APIs from the java.sql.Connection
class. These APIs were introduced with JDBC 4.3 specifications and JDK 9. For more information about the driver's implementation of these APIs, see JDBC 4.3 compliance for the JDBC Driver.
Support for SQL Data Discovery and Classification
Microsoft JDBC Driver 7.0 for SQL Server provides support for SQL Data Discovery and Classification with any target database that supports this feature. The driver now exposes SQLServerResultSet.getSensitivityClassification()
APIs to extract this information from the fetched ResultSet
.
For more information about how to use this feature with the JDBC Driver, see the sample in SQL Data Discovery and Classification.
Added connection property: useBulkCopyForBatchInsert
Microsoft JDBC Driver 7.0 for SQL Server introduces a new connection property, useBulkCopyForBatchInsert
. This property is supported only for Azure Synapse Analytics.
This property is disabled by default. You can enable it to increase performance of user applications when you're pushing large amounts data to Azure Synapse Analytics. Enabling this property changes the behavior of batch insert operations to switch to bulk copy operations with user-provided data. For more information about this property and its limitations, see Using Bulk Copy API for batch insert operation.
Added connection property: cancelQueryTimeout
Microsoft JDBC Driver 7.0 for SQL Server introduces a new connection property, cancelQueryTimeout
, to cancel queryTimeout
on java.sql.Connection
and java.sql.Statement
objects.
Added Azure Key Vault Provider constructors
Microsoft JDBC Driver 7.0 for SQL Server reintroduces a previously removed constructor, for SQLServerColumnEncryptionAzureKeyVaultProvider
. It allowed authentication through a custom method implemented over SQLServerKeyVaultAuthenticationCallback
to fetch an access token.
The new constructors have the following definition:
/* This constructor is added to provide backward compatibility with 6.0
* version of the driver. It is marked deprecated for removal in the next
* stable release.
*/
@Deprecated
public SQLServerColumnEncryptionAzureKeyVaultProvider(
SQLServerKeyVaultAuthenticationCallback authenticationCallback,
ExecutorService executorService) throws SQLServerException;
/*New constructor to replace the above constructor*/
public SQLServerColumnEncryptionAzureKeyVaultProvider(
SQLServerKeyVaultAuthenticationCallback authenticationCallback) throws SQLServerException;
Updated "Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java" version: 1.6.0
Microsoft JDBC Driver 7.0 for SQL Server has updated its Maven dependency on "Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java" to version 1.6.0. For more information about dependencies, see Feature dependencies of the Microsoft JDBC Driver for SQL Server.
6.4
Download Microsoft JDBC Driver 6.4 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 6.4 for SQL Server (tar.gz)
Version number: 6.4.0
Released: February 27, 2018
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Microsoft JDBC Driver 6.4 for SQL Server is fully compliant with JDBC specifications 4.1 and 4.2. The jars in the 6.4 package are named according to Java version compatibility. For example, the mssql-jdbc-6.4.0.jre8.jar file from the 6.4 package must be used with Java 8.
Support for JDK 9
The driver supports JDK version 9.0 in addition to JDK 8.0 and 7.0.
JDBC 4.3 compliance
The driver supports the Java Database Connectivity API 4.3 specification, in addition to 4.1 and 4.2. The JDBC 4.3 API methods are added but not implemented yet. For details, see JDBC 4.3 compliance for the JDBC Driver.
Added connection property: sslProtocol
A new connection property lets users specify the TLS protocol keyword. Possible values are: "TLS", "TLSv1", "TLSv1.1", and "TLSv1.2". For details, see SSLProtocol.
Deprecated connection property: fipsProvider
The connection property fipsProvider
is removed from the list of accepted connection properties. For details, see the related GitHub pull request.
Added connection properties for specifying a custom TrustManager
The driver now supports specifying a custom TrustManager with added trustManagerClass
and trustManagerConstructorArg
connection properties. You can dynamically specify a set of certificates that are trusted on a per-connection basis without modifying the global settings for the Java virtual machine (JVM) environment.
Added support for datetime/smallDatetime in table-valued parameters
The driver now supports the datatypes datetime
and smallDatetime
when you're using table-valued parameters (TVPs).
Added support for the sql_variant datatype
The JDBC Driver now supports sql_variant
datatypes to be used with SQL Server. The sql_variant
datatype is also supported with features such as TVPs and bulk copy with the following limitations:
For date values:
When you're using a TVP to populate a table that contains
datetime
,smalldatetime
, ordate
values stored in asql_variant
column, calling thegetDateTime()
,getSmallDateTime()
, orgetDate()
method on the result set doesn't work and throws the following exception:java java.lang.String cannot be cast to java.sql.Timestamp
As a workaround, use the
getString()
orgetObject()
method instead.Using a TVP with sql_variant for null values:
If you're using a TVP to populate a table and send a NULL value to the
sql_variant
column type, you encounter an exception. Inserting a NULL value with the column typesql_variant
in a TVP is currently not supported.
Implemented prepared statement metadata caching
The JDBC Driver has implemented prepared statement metadata caching for performance improvement. The driver now supports caching prepared statement metadata in the driver with disableStatementPooling
and statementPoolingCacheSize
connection properties. This feature is disabled by default. For more information, see Prepared statement metadata caching for the JDBC Driver.
Added support for Azure AD Integrated Authentication on Linux/macOS
The JDBC Driver now supports Azure Active Directory (Azure AD) Integrated Authentication on all supported operating systems (Windows, Linux, and macOS) with Kerberos. Alternatively, on Windows operating systems, users can authenticate with mssql-jdbc_auth-<version>-<arch>.dll.
Updated "Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java" version: 1.4.0
The JDBC Driver has updated its Maven dependency on "Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java" to version 1.4.0. For more information about dependencies, see Feature dependencies of the Microsoft JDBC Driver for SQL Server.
6.2
Download Microsoft JDBC Driver 6.2 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 6.2 for SQL Server (tar.gz)
Version number: 6.2.2
Released: September 29, 2017
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Microsoft JDBC Driver 6.2 for SQL Server is fully compliant with JDBC specifications 4.1 and 4.2. The jars in the 6.2 package are named according to Java version compatibility. For example, the mssql-jdbc-6.2.2.jre8.jar file from the 6.2 package is recommended for use with Java 8.
6.2 Releases
Version number: 6.2.2
Released: October 3, 2017
Fixed issues:
- Updated ADAL4J dependency to version 1.2.0 and Azure Key Vault dependency to version 1.0.0
Version number: 6.2.1
Released: July 14, 2017
Fixed issues:
- Fixed an issue when running queries without parameters using
preparedStatement
Version number: 6.2.0
Released: June 30, 2017
Note
An issue with the metadata caching improvement was found in the JDBC 6.2 RTW released on June 29, 2017. The improvement was rolled back and new jars (version 6.2.1) were released on July 17, 2017.
Another improvement upgraded the Azure Key Vault dependent library version to 1.0.0, and new jars (version 6.2.2) were released on October 19, 2017.
Download the latest updates for JDBC Driver 6.2 via the above links, GitHub, or Maven Central. Please update your projects to use the 6.2.2 release jars. For more information, view release notes for 6.2.1 and 6.2.2.
Azure AD support for Linux
Connect your Linux applications to Azure SQL Database by using Azure AD authentication via username/password and access token methods.
FIPS-enabled JVMs
The JDBC Driver can now be used on JVMs that run in Federal Information Processing Standard (FIPS) 140 compliance mode to meet federal standards on compliance.
Kerberos authentication improvements
The JDBC Driver now has support for:
- Principal/password method for applications where the Kerberos configuration can't be modified or can't retrieve a new token or keytab. This method can be used for authenticating to a SQL Server instance that allows only Kerberos authentication.
- Cross-realm authentication that uses Kerberos Integrated Authentication without explicitly setting the server SPN. The driver now automatically computes the realm even when it isn't provided.
- Kerberos Constrained Delegation by accepting impersonated user credentials as a GSS credential object via data source. This impersonated credential is then used to establish a Kerberos connection.
Added timeouts
The JDBC Driver now supports the following configurable timeouts. You can change them based on your application's needs.
- Query timeout to control the number of seconds to wait before a timeout occurs when you're running a query.
- Socket timeout to specify the number of milliseconds to wait before a timeout occurs on a socket read or accept.
6.1
Version number: 6.1.0
Released: November 17, 2016
Microsoft JDBC Driver 6.1 for SQL Server is fully compliant with JDBC specifications 4.1 and 4.2. This is the initial open-source release of the JDBC Driver. The source code can be found at the GitHub v6.1.0 tag. It builds the mssql-jdbc-6.1.0.jre8.jar and mssql-jdbc-6.1.0.jre7.jar files, which correspond to Java version compatibility.
6.0
Download Microsoft JDBC Driver 6.0 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 6.0 for SQL Server (tar.gz)
Version number: 6.0.8112
Released: January 17, 2017
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Microsoft JDBC Driver 6.0 for SQL Server is fully compliant with JDBC specifications 4.1 and 4.2. The jars in the 6.0 package are named according to their compliance with the JDBC API version. For example, the sqljdbc42.jar file from the 6.0 package is JDBC API 4.2 compliant. Similarly, the sqljdbc41.jar file is compliant with JDBC API 4.1.
To ensure that you have the right sqljdbc42.jar or sqljdbc41.jar file, run the following lines of code. If the output is "Driver version: 6.0.7507.100", you have the JDBC Driver 6.0 package.
Connection conn = DriverManager.getConnection("jdbc:sqlserver://<server>;encrypt=true;user=<user>;password=<password>;");
System.out.println("Driver version: " + conn.getMetaData().getDriverVersion());
Always Encrypted
The driver supports the Always Encrypted feature in SQL Server 2016. This feature ensures that sensitive data is never seen in plaintext in a SQL Server instance. Always Encrypted works by transparently encrypting the data in the application, so that SQL Server handles only the encrypted data and not plaintext values. Even if the SQL Server instance or the host machine is compromised, all an attacker can get is ciphertext of sensitive data. For details, see Using Always Encrypted with the JDBC Driver.
Internationalized domain names
The driver supports internationalized domain names (IDNs) for server names. For details, see "Using International Domain Names" in the International features of the JDBC Driver article.
Parameterized queries
The driver now supports retrieving parameter metadata with prepared statements for complex queries, such as subqueries and/or joins. This improvement is available only when you're using SQL Server 2012 and newer versions.
Azure Active Directory
Azure AD authentication is a mechanism of connecting to Azure SQL Database using identities in Azure AD. Use Azure AD authentication to centrally manage identities of database users and as an alternative to SQL Server authentication.
You can use JDBC Driver 6.0 to specify your Azure AD credentials in the JDBC connection string to connect to Azure SQL Database. For details, see the authentication property in the Setting the connection properties article.
Table-valued parameters
TVPs provide an easy way to marshal multiple rows of data from a client application to SQL Server without requiring multiple round trips or special server-side logic for processing the data. You can use TVPs to encapsulate rows of data in a client application and send the data to the server in a single parameterized command. The incoming data rows are stored in a table variable that you can then operate on by using Transact-SQL. For details, see Using table-valued parameters.
Always On Availability Groups
The driver now supports transparent connections to Always On Availability Groups. The driver quickly discovers the current Always On topology of your server infrastructure and connects to the current active server transparently.
4.2
Download Microsoft JDBC Driver 4.2 for SQL Server (self-extracting exe)
Download Microsoft JDBC Driver 4.2 for SQL Server (tar.gz)
Version number: 4.2.8112
Released: August 24, 2015
If you need to download the driver in a language other than the one detected for you, you can use these direct links.
For the driver in a self-extracting exe file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
For the driver in a tar.gz file: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Microsoft JDBC Driver 4.2 for SQL Server is fully compliant with JDBC specifications 4.1 and 4.2. The jars in the 4.2 package are named according to their compliance with the JDBC API version. For example, the sqljdbc42.jar file from the 4.2 package is JDBC API 4.2 compliant. Similarly, the sqljdbc41.jar file is compliant with JDBC API 4.1.
To ensure you have the right sqljdbc42.jar or sqljdbc41.jar file, run the following lines of code. If the output is "Driver version: 4.2.6420.100", you have the JDBC Driver 4.2 package.
Connection conn = DriverManager.getConnection("jdbc:sqlserver://<server>;encrypt=true;user=<user>;password=<password>;");
System.out.println("Driver version: " + conn.getMetaData().getDriverVersion());
Support for JDK 8
The driver supports JDK version 8.0 in addition to JDK 7.0, 6.0, and 5.0.
JDBC 4.1 and 4.2 compliance
The driver supports Java Database Connectivity API 4.1 and 4.2 specifications, in addition to 4.0. For details, see JDBC 4.1 compliance for the JDBC Driver and JDBC 4.2 compliance for the JDBC Driver.
Bulk copy
You use the bulk copy feature to quickly copy large amounts of data into tables or views in SQL Server databases. For details, see Using bulk copy with the JDBC Driver.
XA transaction rollback option
The driver has new timeout options for existing automatic rollback of unprepared transactions. For details, see Understanding XA transactions.
New Kerberos principal connection property
The driver uses a new connection property to facilitate flexibility with Kerberos connections. For details, see Using Kerberos Integrated Authentication to connect to SQL Server.
4.1
Version number: 4.1.8112
Released: December 12, 2014
Support for JDK 7
The driver supports JDK version 7.0 in addition to JDK 6.0 and 5.0.
Itanium not supported for JDBC Driver applications
Microsoft JDBC Driver for SQL Server isn't supported on Itanium computers.