JDBC over SSL connection from Oracle FDMEE failed

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