Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When using JDK >= 16 with Snowflake, authentication fails with a stack trace #410

Open
janblom opened this issue Apr 15, 2024 · 0 comments
Assignees
Labels
bug WhiteRabbit Issue concerning the creation of scan report

Comments

@janblom
Copy link
Collaborator

janblom commented Apr 15, 2024

Describe the bug
There is a documented problem with the Snowflake JDBC driver when running WhiteRabbit with a JDK/JRE version 16 or newer.
See here for an in depth description and the advised short term workarounds, see here for the issue on github

To Reproduce
Steps to reproduce the behavior:
Using WhiteRabbit either throuhg the GUI or CLI, when WhiteRabbit attempts to connect to Snowflake, a failure will be reported with a stack trace. This stack trace will contain a fragment similar to the following:

Caused by: java.lang.reflect.InaccessibleObjectException: Unable to make field long java.nio.Buffer.address accessible: module java.base does not "opens java.nio" to unnamed module @40f9161a
        at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:357)
        at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:297)
        at java.base/java.lang.reflect.Field.checkCanSetAccessible(Field.java:177)
        at java.base/java.lang.reflect.Field.setAccessible(Field.java:171)
        at net.snowflake.client.jdbc.internal.apache.arrow.memory.util.MemoryUtil.<clinit>(MemoryUtil.java:87)

Expected behavior
WhiteRabbit should connect to Snowflake and continue as normal.

Workaround
Please implement the workaround as documented here (under Solution by setting the environment variable JAVA_OPTS to the appropriate value for JDK 16 or JDK 17. Please not that JAVA_OPTS should be set and available in the environment before you start WhiteRabbit.

Additional context
This only applies to WhiteRabbit v1.0.0 and higher (and the release candidates).

This issue needs to be solved in the dependencies mentioned by Snowflake. There is no universal solution available that would work in all Java/JDK versions supported by WhiteRabbit.

@janblom janblom added the bug label Apr 15, 2024
@janblom janblom self-assigned this Apr 15, 2024
@janblom janblom added the WhiteRabbit Issue concerning the creation of scan report label Apr 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug WhiteRabbit Issue concerning the creation of scan report
Projects
None yet
Development

No branches or pull requests

1 participant