Simple select command fails when using SQL Workbench/J with JDBC driver

[pjm4github]

I don't know where to begin to debug this.
This is running on Windows 10 box

An error occurred when executing the SQL command:
-- @WbResult MYTABLE
SELECT * FROM MYDB.MYSCHEMA.MYTABLE limit 10

JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:577). [SQL State=XX000, DB Errorcode=200001]
1 statement failed.

Execution time: 0.22s

Log file shows this setup:

2022-08-04 15:11:27 INFO Setting default locale to: en
2022-08-04 15:11:27 INFO Starting SQL Workbench/J, Build 128 (2021-11-01 17:46)
2022-08-04 15:11:27 INFO Java version=18.0.2, java.home=C:\Users\xxxxx\AppData\Local\Java, vendor=Oracle Corporation, name=Java HotSpot(TM) 64-Bit Server VM
2022-08-04 15:11:27 INFO Operating System=Windows 10, version=10.0, platform=amd64
2022-08-04 15:11:27 INFO Available memory: 23360MB

[wise-coders]

I get also this error, with simple queries like:

SELECT table_name, view_definition FROM TEST.INFORMATION_SCHEMA.views WHERE table_schema='${schema}'

net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator .
I am using the driver version 3.13.25

[BDeus]

The Snowflake JDBC driver is not ready to work as is with Java >= 17 see #589.
I have a workaround with setting JDBC_QUERY_RESULT_FORMAT = JSON in extended properties

[sfc-gh-igarish]

Please track by other similar issue.

[sfc-gh-igarish]

To clean up and re-prioritize more pressing bugs and feature requests we are closing all issues older than 6 months as of March 1, 2023. If there are any issues or feature requests that you would like us to address, please create them according to the new templates we have created. For urgent issues, opening a support case with this link Snowflake Community is the fastest way to get a response.