microsoft sql server jdbc driver install

Similar to the HTTP to HTTPS default changes made in web browsers a few years back (and the security reasons for them), we are changing the default value of the `Encrypt` connection option from `false` to `true`. With the increased emphasis on secure-by-default, the growing use of cloud databases, and the need to ensure connections are secure, it's time for this backwards-compatibility-breaking change. There a couple breaking changes in 10.2 over previous releases that may affect a lot of users. Fixed TDSParser stuck on TDS_COLMETADATA issue, which could result in a hang for certain queries ( #1662)īreaking Changes Encrypt = true, by default.Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy 1640.Fixed an issue where Statement.closeOnCompletion() would cause a Null Pointer Exception 1639.Fix for Bulkcopy multi byte characters in char/varchar columns 1671.Fix for Azure AD Interactive authentication timeout 1696.Updated Bouncy Castle dependency version 1735.Updated Azure library dependency versions to address vulnerability issues 1733.Updated enclave provider to use a non-blocking random method 1734.Deprecated AADSecurePrincipalId/AADSecurePrincipalSecret 1693.BREAKING CHANGE - Changed certificate validation behavior to validate when encryption is negotiated from either the client or the server side, not just the client side 1731.BREAKING CHANGE - Default Encrypt to true 1697.Canonical host name resolution when realm is provided in connection string 1730.Support for datetimeoffset with sql_variant 1673.Retry for intermittent Java NativeSeedGenerator 1705.

Added 4219 to transient error list 1643.

Added check for closed statement to registerColumnEncryptionKeyStoreProvidersOnStatement 1644.

Support for multi user scenarios for Always Encrypted key store providers 1614 ( read more).

Idle Connection Resiliency Feature 1669 ( read more).

Version 10.2.0 brings several added features, changes, and fixed issues over the previous production release. Version 10.2 of the Microsoft JDBC Driver for SQL Server has been released.

Microsoft sql server jdbc driver install