hive icon indicating copy to clipboard operation
hive copied to clipboard
verified publisher icon apache

Bump com.microsoft.sqlserver:mssql-jdbc from 6.2.1.jre8 to 11.1.0.jre8-preview

Open dependabot[bot] opened this issue 2 months ago • 3 comments

Bumps com.microsoft.sqlserver:mssql-jdbc from 6.2.1.jre8 to 11.1.0.jre8-preview.

Release notes

Sourced from com.microsoft.sqlserver:mssql-jdbc's releases.

[11.1.0] Preview Release

Added

  • Added new connection string property prepareMethod to toggle use of sp_prepare 1719
  • Added new encrypt options for TDS 8.0 support 1757
  • Added Configurable IPv6 Support 1766
  • Added serverCertificate connection property for encrypt=strict 1773
  • Added option for NONE attestation protocol 1779

Changed

  • Added encrypt utility to obfuscate password strings in memory 1780
  • Simplified traceID creation in DataSource and PooledConnection 1747
  • Refactored SQLServerColumnEncryptionAzureKeyVaultProvider usage in SQLServerConnection 1774

Fixed issues

  • Removed extra call to executeCommand() within connectionCommand() 1754
  • Fixed warnings for Implicit narrowing conversion in compound assignment 1758
  • Added check for MSAL library when attempting ActiveDirectoryServicePrincipal authentication 1759
  • Fixed Managed Identity retry interval to exponential backoff properly 1770

[10.2.4] Hotfix & Stable Release

Fixed issues

  • Address a hostname validation vulnerability by securely parsing certificate common names. #2802 What was fixed: Secure hostname validation is enforced by replacing the vulnerable CN parsing logic in SQLServerCertificateUtils.java, preventing spoofing attacks. Who benefits: All users of the SQL Server JDBC driver, especially those relying on TLS for secure connections, benefit from improved certificate validation.

[10.2.3] HotFix & Stable Release

Fixed issues

  • Fixed incorrect update counts when timeout occurs in batch queries 2024
  • Fixed incorrect token expiration date when using Azure Functions 2025
  • Fixed null SQL state and zero error code when database exception is thrown 2027

[10.2.2] HotFix & Stable Release

Fixed issues

  • Clear prepared statement cache on idle connection resiliency reconnections 1982
  • Fix for setting KeepAlive extended options 1986
  • Fixed issue where the driver may assert when canceling a statement 1987
  • Fixed callable statement index out of bounds error 1988
  • Fixed issue not checking for DONE token errors so exceptions are ignored 1990
  • Fixed query cancellation bug 1996

[10.2.1] HotFix & Stable Release

Fixed issues

  • Refactored Idle Connection Resiliency timeout to use existing SharedTimer 1794
  • Fixed Managed Identity retry interval to exponential backoff properly 1770
  • Removed extra call to executeCommand() within connectionCommand() 1754

[10.2.0] Stable Release

Added

  • Support for datetimeoffset with sql_variant 1673
  • Canonical host name resolution when realm is provided in connection string 1730

... (truncated)

Commits

Dependabot compatibility score

You can trigger a rebase of this PR by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

  • @dependabot rebase will rebase this PR
  • @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
  • @dependabot merge will merge this PR after your CI passes on it
  • @dependabot squash and merge will squash and merge this PR after your CI passes on it
  • @dependabot cancel merge will cancel a previously requested merge and block automerging
  • @dependabot reopen will reopen this PR if it is closed
  • @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
  • @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
  • @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the Security Alerts page.

Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

dependabot[bot] avatar Nov 07 '25 08:11 dependabot[bot]

Quality Gate Passed Quality Gate passed

Issues
20 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

sonarqubecloud[bot] avatar Nov 07 '25 09:11 sonarqubecloud[bot]

@aturoczy We have not removed support for MSSQL although it is not tested actively. The SQL scripts are maintained when there are new schema changes. But Hive uses JDK21 now. We should use JDK21 compatible driver. https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver17

Also we should not be using something thats a preview jar like this PR does.

nrg4878 avatar Dec 09 '25 18:12 nrg4878

@difin Are you OK to bump this version to latest and close this ticket?

aturoczy avatar Dec 11 '25 23:12 aturoczy