RE: Java extensions directory vs Excel generation

We have very limited usage of the POI files, but ours are all in
/Medtron/java/poi-xx They all used to just be in the /Medtron/java
directory, but we split them out last year to test some things in the
newer version that had compatibility issues. The default poi is in the
default classpath. If we need to use another one, we add it before
starting the program.

Here is an old article from Scott Klement. It was this one or one like
it that had us set it up the way we do.
http://www.easy400.net/hssfcgi/documentation/20100225.htm

Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----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.

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

--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD