Workato · On-prem agent
Snowflake JDBC driver internal error (ArrowBuf.getDirectBuffer)
Short answer
This error appears on a select query in a custom SQL action against Snowflake through the on-prem agent. Add &JDBC_QUERY_RESULT_FORMAT=JSON to the connection URL.
VerifiedLast verified
01Error text
JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.ArrowBuf.getDirectBuffer(ArrowBuf.java:231).: XX00002Likely causes
- The error occurs on a select query in a custom SQL action when the Snowflake JDBC driver returns results in Arrow format.
03How to fix it
- Add
&JDBC_QUERY_RESULT_FORMAT=JSONto the connection URL. This is the recommended fix. - Or use an older Snowflake JDBC driver, for example 3.9.2.
- Restart the agent and rerun the job.
04Official documentation
→Related errors
- Failed to initialize MemoryUtil (Databricks JDBC)This error comes from the Databricks JDBC driver's use of Apache Arrow for data transfer. Add EnableArrow=0 to the JDBC URL.
- java.lang.OutOfMemoryError: Java heap space (on-prem agent)This error in the on-prem agent log means the agent does not have enough memory for a large job or payload. Raise the Java heap with the -Xmx option and restart the agent.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer