JDBC and DBVisualizer

On connecting with JDBC setup using DBVisualizer, I am getting below error using LATEST JDBC drive off the download page:

2020-07-13 10:51:10,067 [UserServer-1] INFO com.dremio.ConnectionLog - [4774dff0-2f6b-4c94-8d2c-8c229572c5e2] Connection opened.
Endpoint: :37165
Protocol Version: 5
Record Type: DREMIO
Record Formats: DREMIO_1_4, DREMIO_0_9
Support Complex Types: true
Name: Dremio JDBC Driver
Version: 4.5.0-202006180205030236-1a5d28da (4.5.0)
Application: 45643@wo-MacBook-Pro.local
User Properties:
direct=:31010
user=wonderful

2020-07-13 10:51:10,067 [UserServer-1] WARN c.dremio.sabot.rpc.user.UserSession - Ignoring unknown property: DIRECT
2020-07-13 10:51:10,165 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /:31010 <–> /:37165 (user client)
2020-07-13 10:51:10,165 [UserServer-1] INFO com.dremio.ConnectionLog - [4774dff0-2f6b-4c94-8d2c-8c229572c5e2] Connection Closed

Well, the connection is closed with below error in DBVisualizer:

Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)

This may be related to the JDK version that DbVisualizer is using.

Please configure DbVisualizer to run with an older JDK than JDK 11:

As is, with latest DBVisualizer download, this 3.2.8 Dremio JDBC driver works:

http://download.dremio.com/jdbc-driver/3.2.8-201907180222520740-08f2b54/

Any ideas?

@desi, older versions of Dremio’s JDBC driver may work with Java 11, but not our newer versions (as you have seen). If you want to try the new version of the Dremio JDBC Driver with Java 11, then you will have to pass this parameter with the runtime: -Dcdjd.io.netty.tryReflectionSetAccessible=true

1 Like