In RDG installed databricks JDBC driver but when we create conenction in OAC getting below error.

Question

In RDG(remote data gateway) installed databricks JDBC driver but when we create datasource conenction in OAC(dv) getting below error in RDG logs.Please someone advise what to do? Error- 2025-02-08 00:46:19 ERROR datasource:pool-3-thread-1 - java.sql.SQLException [Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: javax.net.ssl.SSLException: Connection reset. Cause - [Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: javax.net.ssl.SSL Exception: Connection reset. com.databricks.client.hivecommon.api.HS2Client.handleTTransportException(Unknown Source) com.databricks.client.spark.jdbc.DownloadableFetchClient.handleTTransportException(Unknown Source) com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source) com.databricks.client.hivecommon.api.HS2Client.(Unknown Source) com.databricks.client.spark.jdbc.DownloadableFetchClient.(Unknown Source) com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source) com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source) com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source) com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source) com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source) com.databricks.client.jdbc.core.LoginTimeoutConnection$1.call(Unknown Source) com.databricks.client.jdbc.core.LoginTimeoutConnection$1.call(Unknown Source) java.util.concurrent.FutureTask.run(FutureTask.java:266) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:750)

User_C3XPZ · Answer

Below are the tests on non working server:

[oracle@goblxdvo java]$ openssl s_client -connect aap-analytics-lab.cloud.databricks.com:443 -tls1_2

CONNECTED(00000003)

write:errno=104

no peer certificate available

No client certificate CA names sent

SSL handshake has read 0 bytes and written 0 bytes

New, (NONE), Cipher is (NONE)

Secure Renegotiation IS NOT supported

Compression: NONE

Expansion: NONE

No ALPN negotiated

SSL-Session:

Protocol  : TLSv1.2

Cipher    : 0000

Session-ID:

Session-ID-ctx:

Master-Key:

Key-Arg   : None

Krb5 Principal: None

PSK identity: None

PSK identity hint: None

Start Time: 1739328480

Timeout   : 7200 (sec)

Verify return code: 0 (ok)

[oracle@goblxdvoa java]$ openssl version

OpenSSL 1.0.2k-fips  26 Jan 2017

[oracle@goblxdvo java]$

====

Below is the working server:

[oracle@goblxdvoacconfig]$ openssl s_client -connect aap-analytics-lab.cloud.databricks.com:443 -brief -tls1_2

Connecting to 172.27.152.242

CONNECTION ESTABLISHED

Protocol version: TLSv1.2

Ciphersuite: ECDHE-RSA-AES256-GCM-SHA384

Peer certificate: C=US, ST=California, L=San Francisco, O=Databricks Inc., CN=.cloud.databricks.com

Hash used: SHA256

Signature type: RSA-PSS

Verification: OK

Supported Elliptic Curve Point Formats: uncompressed

Server Temp Key: ECDH, prime256v1, 256 bits

[oracle@goblxdvconfig]$ openssl version

OpenSSL 3.2.2 4 Jun 2024 (Library: OpenSSL 3.2.2 4 Jun 2024)

User_C3XPZ · Answer

Hi Steve,

Thanks for checking on working server(RHEL9(openjdk version "11.0.25")).  Non working server is RHEL7(openjdk version "1.8.0_442")

Steve F-2 · Answer

Remote Data Gateway is not technically certified with RHEL 9, but it may work

https://www.oracle.com/middleware/technologies/oac-downloads.html

The issue could also be the JDK, use Oracle JDK 1.8.xx (not any OpenJDK versions), so check your echo$PATH and which java command in your shell.