Re: Java extensions directory vs Excel generation

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

If you search the archives, you should find a CL that I posted to set up
the JVM. I recommend keeping just a single version of poi in your classpath
at a time. If you can't find the CL, I can repost it. If you really need
all those versions, maybe you could have multiple versions of your setup
program, and call the correct one at the beginning of each job that uses
poi. But, I believe all the versions you have listed are compatible with
each other.

On Jan 18, 2018 10:46 AM, "Rob Berendt" <rob@xxxxxxxxx> wrote:

> 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