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

User_C3XPZ

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.<init>(Unknown Source)
com.databricks.client.spark.jdbc.DownloadableFetchClient.<init>(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)

Sumanth V -Oracle

@User_C3XPZ -

Is the Data bricks and OAC URL accessible from the machine where data gateway is running? Kindly validate.

SteveF-Oracle

Test the connection with the steps detailed in this knowledge article.

Legacy Support Portal
Security Update For Oracle Analytics (Doc ID 3029871.1)

New Support Portal
Security Update For Oracle Analytics KB127925

User_C3XPZ

Yes its accessble , we have 3 nodes rdg (in this 3 node is new machine with rhel9 openJDK13 is working),but old server(rhel7 openJDK7 not working)

SteveF-Oracle

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.

User_C3XPZ

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")

User_C3XPZ

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)