The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-19-2023 04:17 AM
I am trying to connect to SQL through JDBC from databricks notebook. (Below is my notebook command)
val df = spark.read.jdbc(jdbcUrl, "[MyTableName]", connectionProperties)
println(df.schema)When I execute this command,
with DBR 10.4 LTS it works fine. But after upgrading to DBR 13.0 it throws below error:
SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:XXXXXXXX-XXXXX-XXXXX-XXXXX-XXXXXXXXXXXX
Caused by: SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Caused by: ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Caused by: SunCertPathBuilderException: unable to find valid certification path to requested target
- Labels:
-
Databricks notebook
-
SQL
-
Sqlserver