In addition what @Dave Laycock has written, there is an additional aspect for this specific scenario (at least as I understand it from the screenshots).
The problem is the Apache POI XML handling. The underlying XML Beans library does some custom class-loading at runtime. Through a somewhat "unfortunate" approach this effectively uses the version that comes shipped with IS.
The bottom line is that you cannot use current versions of Apache POI to process XML-based formats (like .xlsx). I had looked at this in early 2024 and found numerous post on Reddit etc. So it is not the fault of webMethods but the weird approach of the XML Beans library.
If you want to process Excel spreadsheets, you could also have a look at https://github.com/JahnTech/webmethods-is-jt_excel
------------------------------
All the best,
Christoph
------------------------------
Original Message:
Sent: Sun December 08, 2024 11:32 PM
From: DONGWOO LEE
Subject: Conflict with commons lib
hi,
I want to use Apache commons-io V2.16.1 in my Java service. My code works fine in standalone mode (not in webMethods), but when I put it into IS it throws an « Exception ».
After some research, I found an older version of this library in "/webMethods/common/lib/ext/". Unfortunately, this jar file cannot be changed to the latest version as it may affect other apps or IS itself.
Is there a way to use my javaservice with commons-io in the « instances/default/lib/jars/custom » folder instead of « /webMethods/common/lib/ext/ »?
thank you for your reply




------------------------------
DONGWOO LEE
------------------------------