Summary/Reported Issue
The error encountered was:
Error connecting to the database: java.sql.SQLException: Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <--> null (user client)Relevant Versions
Reported on Dremio 24.0.x
Other versions may be affected
Troubleshooting Steps
- The user was using a Python script that applied the JayDeBeApi library alongside the legacy driver `dremio-jdbc-driver-24.0.0-202302100528110223-3a169b7c.jar` and JDK 19.
- Using other clients like DBeaver, pure Arrow or ODBC in Python worked as expected.
- After installing JDK 8 we were able to confirm the issue was caused by JDK 19 being incompatible with the driver.
Cause
JDK 19 being incompatible with the driver.
Steps to Resolve
- Using JDK 8 or 11 with 24.x drivers should work.
- Using JDK 11 or 17 with 25.x drivers should work.