Snowflake JDBC erroring out Cannot invoke "java.lang.Throwable.toString()" because the return value of "java.lang.Throwable.getCause()" is null

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi all!

We are trying to connect to snowflake db using JDBC. Test connection works. But if we try to run an aggregation we are getting this error:


2025-03-12T15:12:07,479Z TRACE https-jsse-nio-8443-exec-6 sailpoint.connector.JDBCConnector:97 - Entering executeStatement: Arguments => select  application_key, applicant_id, prefix, last_name, first_name, middle_name from stage - Query ID: null, true
2025-03-12T15:12:08,007Z TRACE https-jsse-nio-8443-exec-6 sailpoint.connector.JDBCConnector:115 - Throwing executeStatement - sailpoint.connector.ConnectorException: 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.<init>(SnowflakeResultSetSerializableV1.java:369).
2025-03-12T15:12:08,008Z TRACE https-jsse-nio-8443-exec-6 sailpoint.connector.JDBCConnector:115 - Throwing execute - sailpoint.connector.ConnectorException: 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.<init>(SnowflakeResultSetSerializableV1.java:369).
2025-03-12T15:12:08,013Z TRACE https-jsse-nio-8443-exec-6 sailpoint.connector.JDBCConnector:115 - Throwing testConfiguration - java.lang.NullPointerException: Cannot invoke "java.lang.Throwable.toString()" because the return value of "java.lang.Throwable.getCause()" is null
2025-03-12T15:12:08,013Z ERROR https-jsse-nio-8443-exec-6 sailpoint.web.ApplicationObjectBean:2865 - Connector failed.
java.lang.NullPointerException: Cannot invoke "java.lang.Throwable.toString()" because the return value of "java.lang.Throwable.getCause()" is null

We made sure that the required driver and jar is available in lib folder. Anyone has any idea on how to fix this issue?

2

from below seems driver is missing , you need to deploy the driver’s jar file
2025-03-12T15:12:08,008Z TRACE https-jsse-nio-8443-exec-6 sailpoint.connector.JDBCConnector:115 - Throwing execute - sailpoint.connector.ConnectorException: JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at

1 Like
3

@kpudasaini there is an OOTB snowflake connector as well if your use case is valid you can use that directly instead of jdbc

4

I have confirmed the driver is there, test connection with “show databases” query works fine but can’t aggregate.

5

Yes. But I am trying to pull data from specific table. The out of box snowflake connector is not designed for that.

1 Like
6

Hi @kpudasaini most probably this is caused by missing transitive dependencies, especially Apache Arrow and related JARs that Snowflake JDBC internally relies on, also Consider using a stable JDBC version as well.

Have a nice and great one!