JDBC over SSL connection from Oracle FDMEE failed

Uncategorized
1

Hello,

We would like to connect from Oracle FDMEE (an ELT tool) to Dremio over SSL (port 443).

From our FDMEE server, network seems opened, and Dremio web interface is reachable. We can authenticate with SSO account.

But FDMEE component cannot create the connection with the following error: SQLException: java.sql.SQLException: Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null ↔ null (user client)

Dremio server is in version 25.2.2-202412182123320447-24bc7017.

Java version used by Oracle FDMEE component: JDK 1.8.0_431.

We currently use jdbc driver dremio-jdbc-driver-24.3.2-202401241821100032-d2d8a497.jar, but we tested all of these (same issue):

  • dremio-jdbc-driver-1.0.8-201707190805180330-27f36e1.jar
  • dremio-jdbc-driver-3.0.6-201812082352540436-1f684f9.jar
  • dremio-jdbc-driver-24.3.2-202401241821100032-d2d8a497.jar
  • dremio-jdbc-driver-25.2.0-202410241428100111-a963b970.jar
  • dremio-jdbc-driver-26.0.5-202509091642240013-f5051a07.jar

We use this jdbc URL: “jdbc:dremio:direct=xxxxxx-xxxxxx.xxxxxx.com:443;ssl=true”,

Can you help please ?

In advance, thank you.

Ben

2

log_fdmee_ODI_SESSION_281.zip (9.2 KB)

3

@benoit.droulin Connecting from Oracle to Dremio is currently not supported. What are you trying to achieve by doing this?

4

Hello Balaji,

We are using jdbc connection with jython script to retrieve sql data from a Dremio view.

Regards,

Ben

5

@benoit.droulin Let us narrow down this. Can you try connecting from DBeaver to Dremio using the same jdbc driver? Does that work?

6

Hi Balaji, we succeeded to connect through jdbc 31010 port. Strangely, dbvizualizer Dremio connection was not working from FDMEE server, but it works now via the Oracle FDMEE component.

Thank you for your help.

Ben

7

A reachable web UI only confirms HTTPS to the web endpoint; the JDBC driver needs the Dremio Flight/RPC connection to reach the correct service through the proxy or load balancer. Check that port 443 forwards the Flight traffic without terminating or rewriting it, and test from the FDMEE host. Also remove the space shown after direct= in the URL. Since the login uses SSO, verify the driver is configured with a JDBC-supported authentication method; browser SSO access alone doesn’t establish that JDBC can authenticate.