Talend Runtime - API with Snowflake connection : error

DerfelCadarn — Wed, 04 Sep 2024 18:01:09 GMT

Hello,

I have created a simple REST web service using Talend (Integration and not Route) that connects to a Snowflake table and returns the data from this table. Locally, from my Studio, it works. However, when I deploy and test the web service on Talend Runtime, it generates an error on the component that reads the Snowflake table "tDBInput_2": "java.io.IOException: Error processing query".

I replaced my query with "SELECT '1' FROM DUAL", but the error remains the same.

Therefore, I thought I needed to install the Snowflake JDBC Driver in Karaf. I followed this procedure: https://help.talend.com/en-US/esb-container-administration-guide/8.0/installing-using-simple-copy-to-deploy-folder which is not working: I placed my snowflake-jdbc-3.19.0.jar file in all directories and subdirectories of the <TalendRuntimePath>/lib folder, but nothing happens.

The error in the tesb.log file is as follows:

2024-09-04T19:13:43,451 | ERROR | qtp1409286757-360 | snowflake.client.log.JDK14Logger 144 | 434 - urw_talend_asi2-eu.WS_Get_Buildings - 0.1.2 | Exception creating result
java.lang.ExceptionInInitializerError: null
at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27) ~[snowflake-jdbc-3.13.30.jar:3.13.30]
at net.snowflake.client.jdbc.internal.apache.arrow.memory.DefaultAllocationManagerFactory.<clinit>(DefaultAllocationManagerFactory.java:26) ~[snowflake-jdbc-3.13.30.jar:3.13.30]
at java.lang.Class.forName0(Native Method) ~[?:?]

at java.lang.Thread.run(Thread.java:840) ~[?:?]
Caused by: java.lang.RuntimeException: Failed to initialize MemoryUtil. Was Java started with `--add-opens=java.base/java.nio=ALL-UNNAMED`? (See https://arrow.apache.org/docs/java/install.html)
at net.snowflake.client.jdbc.internal.apache.arrow.memory.util.MemoryUtil.<clinit>(MemoryUtil.java:141) ~[snowflake-jdbc-3.13.30.jar:3.13.30]
... 85 more
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 @7f2c0b06
at java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:354) ~[?:?]

Could you help me with this one ?

Thanks.

topic Talend Runtime - API with Snowflake connection : error in Installing and Upgrading

Talend Runtime - API with Snowflake connection : error