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

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)
Answers
-
Is the Data bricks and OAC URL accessible from the machine where data gateway is running? Kindly validate.
0 -
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 KB1279250 -
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)
0 -
Remote Data Gateway is not technically certified with RHEL 9, but it may work
https://www.oracle.com/middleware/technologies/oac-downloads.htmlThe issue could also be the JDK, use Oracle JDK 1.8.xx (not any OpenJDK versions), so check your
echo$PATH
andwhich java
command in your shell.0 -
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")
0 -
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=104no 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)0