topic Re: Trying to connect to DBeaver from Databricks and getting error message in Warehousing & Analytics

Trying to connect to DBeaver from Databricks and getting error message

ckwan48 — Thu, 20 Mar 2025 17:24:38 GMT

I am trying to connect to DBeaver from Databricks and getting this error message:

[Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

unable to find valid certification path to requested target

Re: Trying to connect to DBeaver from Databricks and getting error message

Hubert-Dudek — Wed, 12 Oct 2022 16:50:33 GMT

Can you share your code?

Re: Trying to connect to DBeaver from Databricks and getting error message

Vivian_Wilfred — Wed, 12 Oct 2022 18:52:41 GMT

Hi @Kevin Kim Can you run a netcat and curl -vvv command and share the result? Seems like a certificate issue. Can you load the certificate to the driver and retry? Check this link to import certificate:

https://learn.microsoft.com/en-gb/azure/databricks/kb/python/import-custom-ca-cert

Re: Trying to connect to DBeaver from Databricks and getting error message

Anonymous — Sun, 20 Nov 2022 06:32:12 GMT

Hi @Kevin Kim

Hope all is well!

Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Trying to connect to DBeaver from Databricks and getting error message

Hardy — Tue, 06 Jun 2023 12:35:16 GMT

I have the same issue after upgrading cluster to DBR 12.2. Working fine with DBR 10.4

Re: Trying to connect to DBeaver from Databricks and getting error message

cjangrist — Thu, 02 Nov 2023 13:03:06 GMT

ditto using the latest release runtime 14.1

2023-11-02 06:40:29 destination > WARN c.z.h.p.ProxyConnection(checkException):177 HikariPool-1 - Connection com.databricks.client.hivecommon.jdbc42.Hive42Connection@1bf39d06 marked as broken because of SQLSTATE(08S01), ErrorCode(500593) java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.
at com.databricks.client.hivecommon.api.HS2Client.handleTTransportException(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.spark.jdbc.DowloadableFetchClient.handleTTransportException(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.api.HS2Client.pollForOperationCompletion(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.api.HS2Client.executeStatement(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeRowCountQueryHelper(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeHelperParameter(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.execute(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.databricks.client.jdbc.common.SPreparedStatement.execute(Unknown Source) ~[databricks-jdbc-2.6.25.jar:?]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:?]
at io.airbyte.integrations.destination.jdbc.SqlOperationsUtils.lambda$insertRawRecordsInSingleQuery$1(SqlOperationsUtils.java:103) ~[io.airbyte.airbyte-integrations.bases-bases-destination-jdbc-20.10.23.jar:?]
at io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:46) ~[io.airbyte.airbyte-db-db-lib-20.10.23.jar:?]
at io.airbyte.integrations.destination.jdbc.SqlOperationsUtils.insertRawRecordsInSingleQuery(SqlOperationsUtils.java:74) ~[io.airbyte.airbyte-integrations.bases-bases-destination-jdbc-20.10.23.jar:?]
at io.airbyte.integrations.destination.jdbc.SqlOperationsUtils.insertRawRecordsInSingleQuery(SqlOperationsUtils.java:38) ~[io.airbyte.airbyte-integrations.bases-bases-destination-jdbc-20.10.23.jar:?]
at io.airbyte.integrations.destination.databricks.DatabricksSqlOperations.insertRecordsInternal(DatabricksSqlOperations.java:67) ~[io.airbyte.airbyte-integrations.connectors-destination-databricks-20.10.23.jar:?]