Urgent! ERROR in reading XLSX file from SFTP location via Java Snippet
Urgent help needed:
I am trying to connect SFTP through Java Snippet (for some security reason, I cannot use SSH Node. In my case, SSH node doesn’t work) in KNIME to read the content of the XLSX file (Connection working fine. Problem is in reading XLSX).
I tested the code in Eclipse, and it runs perfectly fine (the dependencies I used are attached below).
Now, when I implemented this code in the KNIME, I got:
WARN Java Snippet 3:22 Evaluation of java snippet failed for row “Row0”.The exception is caused by line 102 of the snippet. Exception message (NoSuchMethodError): 'org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream$Builder org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.builder()’
While I used the same libraries here:
The problem is that it says the method is not found, while that commons-io jar has the method.
I know this because the Eclipse project gave me the same issue, which worked when I changed the version of the commons-io. Now, why is KNIME giving me this issue? And how to solve this.
Thanks in Advance.