Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
DerfelCadarn
Contributor III
Contributor III

Talend Runtime - API with Snowflake connection : error

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... 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.

Labels (3)
0 Replies