JDBC drivers 10.2 11.2 from Microsoft SQL Server 2017/2019 are not compatible with UVMS or Reporter
search cancel

JDBC drivers 10.2 11.2 from Microsoft SQL Server 2017/2019 are not compatible with UVMS or Reporter

book

Article ID: 259027

calendar_today

Updated On: 03-30-2023

Products

CA Automic Dollar Universe

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.

In the future, we plan to add Compatibility with MS SQL Server 2017 and 2019 and their corresponding JDBC Drivers 10.x and superior with our Products.

This will be done via the Enhancement Story PMDU-2726

Additional Information

https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16

Powered by Wolken Software