I have a /java dir, with sub-dir for different functions (e.g. HSSF, PGP, JDBC).
Different versions of JAR's could be handled by setting the job CLASSPATH. The one caveat being you have to set CLASSPATH before the JVM starts, and it can't be changed.
________________________________
From: Rob Berendt <rob@xxxxxxxxx>
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.
http://www-01.ibm.com/support/docview.wss?uid=nas8N1014801
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
http://www.dekko.com
midrange.com
