I simply created a directory on /root called poi and placed them all in the directory & it has been there for years & I have had no issues.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, January 18, 2018 9:46 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Java extensions directory vs Excel generation
We've been given grief by IBM for an unrelated issue for having these objects in the directory they are in /QIBM/UserData/Java400/ext/poi-ooxml-schemas-3.14-20160307.jar
/QIBM/UserData/Java400/ext/poi-ooxml-schemas-3.14-20160307.jar
/QIBM/UserData/Java400/ext/ooxml-security-1.1.jar
/QIBM/UserData/Java400/ext/cellutil.jar
/QIBM/UserData/Java400/ext/dom4j-1.6.1.jar
/QIBM/UserData/Java400/ext/jsr173_1.0_api.jar
/QIBM/UserData/Java400/ext/jtds-1.2.5.jar
/QIBM/UserData/Java400/ext/poi-3.14-20160307.jar
/QIBM/UserData/Java400/ext/poi-ooxml-3.14-20160307.jar
/QIBM/UserData/Java400/ext/poi 3.10.1 backup /QIBM/UserData/Java400/ext/ooxml-schemas-1.3.jar
/QIBM/UserData/Java400/ext/poi-3.10.1 - current
/QIBM/UserData/Java400/ext/poi3.14 new testing /QIBM/UserData/Java400/ext/stax-api-1.0.1.jar
/QIBM/UserData/Java400/ext/xmlbeans-2.6.0.jar
It has been recommended that they are left in their appropriate directories.
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww-01.ibm.com%2Fsupport%2Fdocview.wss%3Fuid%3Dnas8N1014801&data=02%7C01%7Ctommy.holden%40tmcat.com%7C4425ca8a017f46118cae08d55e8aa0db%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636518871861506877&sdata=MbWdyKt8DtB5wtsNJEZKQbjn%2FVW4XF8Q9ZjpVEaega0%3D&reserved=0
Some questions:
1 - Where should I be using instead?
2 - Do I search for these same objects or does Java know to look in the jar files for the stuff it needs? IOW some newer version of Java may call the same function but out of file poi....3.25...jar instead of poi....3.14...jar.
3 - What do others, who use the java stuff to generate excel, do?
I expect some response from someone who uses some other utility to generate spreadsheets (such as python) but that really doesn't help me clean up this java. So, yes I am aware of alternatives, but no, instead of pursuing them I want to clean this up instead.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dekko.com&data=02%7C01%7Ctommy.holden%40tmcat.com%7C4425ca8a017f46118cae08d55e8aa0db%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636518871861506877&sdata=SIl9ELIvOKw4PpncCK5JnxQWMEEFy9EXpRuxKkat0Ps%3D&reserved=0
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7Ctommy.holden%40tmcat.com%7C4425ca8a017f46118cae08d55e8aa0db%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636518871861506877&sdata=O%2BWZemcCI1wEyRmGZC6NmNj6DMMiUm4t%2BtD5hCWf8ng%3D&reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7Ctommy.holden%40tmcat.com%7C4425ca8a017f46118cae08d55e8aa0db%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636518871861506877&sdata=udvr87NNdqbqyGuXBkKLXqGU0K4mKxi9pbpywBwy15I%3D&reserved=0.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Famzn.to%2F2dEadiD&data=02%7C01%7Ctommy.holden%40tmcat.com%7C4425ca8a017f46118cae08d55e8aa0db%7C7bedfe4f5ee143529ded95e9c966aa39%7C0%7C0%7C636518871861506877&sdata=jek6r29qE5prRaboFDZ9eFnild%2FC1Fuo3wufpSvcSmQ%3D&reserved=0
midrange.com
