Trying to connect to DBeaver from Databricks and getting error message

[ckwan48]

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

 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

  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

   unable to find valid certification path to requested target

[Hubert-Dudek]

Can you share your code?

[Vivian_Wilfred]

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

[Anonymous]

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!

[Hardy]

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

[cjangrist]

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:?]