cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to connect to DBeaver from Databricks and getting error message

ckwan48
New Contributor III

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

5 REPLIES 5

Hubert-Dudek
Esteemed Contributor III

Can you share your code?

Vivian_Wilfred
Honored Contributor
Honored Contributor

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
Not applicable

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
New Contributor III

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

cjangrist
New Contributor II

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

 

 

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.