
Fixed Idle Connection Resiliency issue where connections could not be recovered more than once 1794. Fixed Managed Identity retry interval to exponential backoff properly 1770įixed unknown token error 0xA3 when selectMethod cursor is used with data classification 1821. Added check for MSAL library when attempting ActiveDirectoryServicePrincipal authentication 1759. Fixed warnings for Implicit narrowing conversion in compound assignment 1758. Removed extra call to executeCommand() within connectionCommand() 1754. Refactored Idle Connection Resiliency timeout to use existing SharedTimer 1794. Updated dependency versions of azure-keyvault and azure-identity 1798. Refactored SQLServerColumnEncryptionAzureKeyVaultProvider usage in SQLServerConnection 1774. Simplified traceID creation in DataSource and PooledConnection 1747. Added encrypt utility to obfuscate password strings in memory 1780. Added support for caching Always Encrypted parameter metadata 1845.
Added support for caching managed identity tokens 1825. Added support for bulk insert of null GUID values 1778.
Added option for NONE attestation protocol 1779. Added serverCertificate connection property for encrypt=strict 1773. Added new encrypt options for TDS 8.0 support 1757. Added new connection string property prepareMethod to toggle use of sp_prepare 1719. To read more about TDS 8.0 in SQL Server, see the SQL Server online documentation. Negotiating TLS first means all TDS connection and feature negotiation happens over an encrypted channel.
Setting Encrypt to "strict" causes the driver to negotiate a TLS connection to the server first, instead of previous behavior where TDS was negotiated, then, if using encryption, TLS would be negotiated inside the TDS stream. This required changing the getEncrypt() API to return a string instead of just a Boolean. To support the new TDS 8.0 protocol where TLS encryption is negotiated before TDS, a new Encrypt option has been added, "strict". There is one breaking change in the 11.2 release over previous production releases. Version 11.2.0 brings several added features, changes, and fixed issues over the previous production release. Version 11.2 of the Microsoft JDBC Driver for SQL Server has been released.