topic Re: Invalid JDBC url in Data Engineering

Invalid JDBC url

elgeo — Fri, 14 Oct 2022 09:19:57 GMT

Hello. I am trying to establish a connection between DBeaver and Databricks. I followed the steps in DBeaver integration with Databricks | Databricks on AWS, but I get the following error while testing the connection:

Could anyone provide any insight? Thank you in advance

Re: Invalid JDBC url

elgeo — Mon, 17 Oct 2022 07:18:06 GMT

Hello. Could someone please help?

Re: Invalid JDBC url

Hubert-Dudek — Thu, 20 Oct 2022 12:00:46 GMT

Additionally, databricks cluster need that config:

spark.driver.extraJavaOptions -Dio.netty.tryReflectionSetAccessible=true

spark.executor.extraJavaOptions -Dio.netty.tryReflectionSetAccessible=true

Re: Invalid JDBC url

elgeo — Wed, 26 Oct 2022 12:23:33 GMT

Hi @Hubert Dudek. Thank you for your reply. Unfortunately, this didn't solve my problem. Any other ideas please? Thank you in advance

Re: Invalid JDBC url

elgeo — Tue, 01 Nov 2022 12:53:51 GMT

Hello. After doing some changes we received the following error:

[Databricks][DatabricksJDBCDriver](700120) Host adb-XXXXXXXXXXXXXXX.azuredatabricks.net cannot be resolved through DnsResolver com.databricks.client.jdbc.rpc.InternalDnsResolver. Error Message: This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server (adb-XXXXXXXXXXXXXX.azuredatabricks.net)

Could anyone please help?

Thank you in advance

Re: Invalid JDBC url

Anonymous — Sun, 27 Nov 2022 12:54:56 GMT

Hi @ELENI GEORGOUSI

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: Invalid JDBC url

elgeo — Mon, 28 Nov 2022 08:04:12 GMT

Hello @Vidula Khanna. We identified the problem. It was due to proxy that the hostname couldn't be resolved

Re: Invalid JDBC url

Anonymous — Mon, 28 Nov 2022 10:36:30 GMT

Hi @ELENI GEORGOUSI

Glad to hear! It's a request that mark an answer as best.

Thanks...