JDBC drivers 10.2 11.2 from Microsoft SQL Server 2017/2019 are not compatible with UVMS or Reporter
Article ID: 259027
Updated On:
Products
Issue/Introduction
JDBC drivers 10.2 and superior versions (11.2 and 12.2 by the time of this article) from Microsoft SQL Server 2017/2019/2022 are not compatible and cannot be used with UVMS or Reporter.
The Enforced TLS communication that was added in mssql-jdbc-10.2.0 (or superior) and the fact that Reporter / UVMS JDBC connection string cannot be customized to allow to set encrypted=false provokes that they fail to connect to the database with this kind of error:
[ERROR] :Unable to initialize DB
[com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:35d73c91-e159-4af1-b3cc-24003b18d073]
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:35d73c91-e159-4af1-b3cc-24003b18d073
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3806)
Environment
Release : 6.x and 7.x
Component : UVMS and Reporter
Database: MS SQL Server
Cause
Caused by a change in JDBC drivers where TLS encryption is enabled by default starting with Microsoft JDBC Driver 10.2 for SQL Server.
Resolution
Use Microsoft JDBC Driver in version 9.4 or inferior.
Additional Information
https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16
Attachments
Feedback
