Hi everyone,
I have an issue and hopefully someone has an idea what I could do!
One of the past developers decided to put the POI libraries under /QIBM/UserData/Java400/ext.
If I try to run following command cmd
java -verbose -Djava.awt.headless=true -jar "/QIBM/ProdData/Access/ACS/Base/acsbundle.jar" /plugin=cldownload /clientfile="/path/to/file.xslx" /sql="select * from database_file" /colheadings=1 /usecollabels /system=localhost
no file has been created.
Trying the same with csv will output a file with data.
Checking log from the verbose option I can see that the process loads the classes from the POI jars in ext-directory instead out of the packaged jars from acsbundle.jar
...
class load: org.apache.poi.ss.usermodel.ClientAnchor from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.HeaderFooter from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.Footer from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.Header from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.Cell from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.CellRange from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.DataValidationHelper from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.SheetConditionalFormatting from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
class load: org.apache.poi.ss.usermodel.AutoFilter from: file:/QIBM/UserData/Java400/ext/poi-3.8-20120326.jar
...
So, now my question is "how can I force the process to use packeged jars from acsbundle.jar"?.
Thank you in advance!
Peter
------------------------------
Peter Brem
------------------------------