After upgrading to Appian 24.2, the following error message appears when trying to query the snowflake connected system through an integration:
JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.util.MemoryUtil at net.snowflake.client.jdbc.internal.apache.arrow.memory.ArrowBuf.getDirectBuffer(ArrowBuf.java:234)
Beginning in Appian 24.2, Appian uses Java 17. Snowflake has an existing issue with its JDBC driver's compatibility with Java 17.
This incompatibility causes the JDBC driver to throw the error message seen above when trying to query through Appian's Connected System object.
This can be remediated by adding the following to the connection URL within the connected system: JDBC_QUERY_RESULT_FORMAT=JSON
JDBC_QUERY_RESULT_FORMAT=JSON
An example URL is provided below:
jdbc:snowflake://<URL>.snowflakecomputing.com/?warehouse=COMPUTE_WH&JDBC_QUERY_RESULT_FORMAT=JSON
This article applies to Appian versions 24.2 and later.
Last Reviewed: July 2024