SSL Exception in JDBC step

Products

• Service Virtualization

Issue/Introduction

Getting below error when executing the VSM in ITR for the JDBC step on the DevTest server machine Workstation. The ITR for same VSM works fine on the local workstation.

There was a SQLException: 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".

Environment

DevTest 10.7.2

Cause

The reason behind this issue on the DevTest server machine was the addition of MSSQL 11 Jar to <DevTest_Home>/lib/shared folder where the MSSQL 8 version of the jar was already present.

The MSSQL 11 driver by default uses SSL communication and caused this issue as the target server was not configured with SSL.

In the local installation only MSSQL 8 version of JAR was present that doesn't use SSL communication.

Resolution

Removing the MSSQL 11 version of Driver from  <DevTest_Home>/lib/shared folder and restarting DevTest services will resolve the issue as it will use MSSQL 8 version of the driver that doesn't use SSL communication by default.