No reason at all. I was just looking into what it could do and I just headed for the latest release figuring it would have the most capabilities.
-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Brown
Sent: Saturday, September 2, 2017 11:23 PM
To: Java Programming on and around the IBM i <java400-l@xxxxxxxxxxxx>
Subject: Re: New to Java on the iSeries and trying to work with Scott Klement's HSSF36
Unless you have a specific reason to go with 3.16 I would suggest 3.8 or later.
Don Brown
From: "John R. Smith, Jr." <smith5646midrange@xxxxxxxxx>
To: "'Java Programming on and around the IBM i'"
<java400-l@xxxxxxxxxxxx>
Date: 03/09/2017 12:50 PM
Subject: New to Java on the iSeries and trying to work with Scott
Klement's HSSF36
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxx>
After further playing around without a lot of success, I decided to step
back from 3.16 to 3.6 to see if maybe something changed that was causing
my issues. I got it to work with 3.6 but I was unsuccessful with 3.16. If
I decide to continue fighting with 3.16, I'll follow up to let everyone
know what I figured out. In the meantime, if someone that understands
this better than me wants to take a crack at 3.16, feel free. I won't be
offended if you figure it out first. 😊
Thanks Don for your help in inadvertently pointing me in the correct
direction.
-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Don
Brown
Sent: Saturday, September 2, 2017 8:56 PM
To: Java Programming on and around the IBM i <java400-l@xxxxxxxxxxxx>
Subject: Re: Newsletter / Marketing: New to Java on the iSeries and trying
to work with Scott Klement's HSSF36
Hi John,
I had an issue just recently where I upgraded a machine from 3.6 to 3.8
and was receiving the same error.
The problem was one of the required jar files was missing.
At 3.6 I had the following jar files installed. One difference was I
installed in the /QIBM/UserData/Java400/ext directory which did not
require the calsspath to be set up. Now I am not suggesting this is the
best option, far from it but it is the easiest to get it working initially
and then you can move the required files to their own directories and use
the classpath to point to the required jar files.
I believe both examples and scratchpad are not required unless you are
directly using classes from those jar files.
Also ensure the jar file name in the classpath matches exactly including
case to the actual files. You will notice my files have the date
incorporated into the name and this is as the files were downloaded from
https://archive.apache.org/dist/poi/release/bin/
Hope this helps
dom4j-1.6.1.jar
jsr173_1.0_api.jar
poi-ooxml-schemas-3.6-20091214.jar
poi-ooxml-3.6-20091214.jar
poi-3.6-20091214.jar
xbean.jar
ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('
/java/poi3.16/poi-3.16.jar:
/java/poi3.16/poi-scratchpad-3.16.jar:
/java/poi3.16/poi-ooxml-3.16.jar:
/java/poi3.16/poi-ooxml-schemas-3.16.jar:
/java/poi3.16/poi-examples-3.16.jar:
/java/poi3.16/poi-excelant-3.16.jar')
LEVEL(*JOB) REPLACE(*YES)
Don Brown
From: "John R. Smith, Jr." <smith5646midrange@xxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Date: 03/09/2017 09:46 AM
Subject: Newsletter / Marketing: New to Java on the iSeries and
trying to work with Scott Klement's HSSF36
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxx>
I wrote Windows based java programs about 20 years ago so I am horribly
rusty on how some of this works.
My iSeries is at 7.1.
I downloaded Scott Klement's HSSF36 and uploaded it to my iSeries into
library POI3.16. I compiled and ran the BUILDHSSF program and it appears
to have completed normally.
I downloaded poi-3.16 and uploaded it to /java/poi3.16.
I think I set my class path correctly using the following command.
ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/java/poi3.16/poi-3.16.jar:/java/poi+
3.16/poi-scratchpad-3.16.jar:/java/poi3.16/+
poi-ooxml-3.16.jar:/java/poi3.16/poi-ooxml-+
schemas-3.16.jar:/java/poi3.16/poi-examples+
-3.16.jar:/java/poi3.16/poi-excelant-3.16.j+
ar') LEVEL(*JOB) REPLACE(*YES)
I also found this so I executed it too. I have no clue what it is doing,
if it is correct, or if it is even needed.
ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES) +
VALUE('-Djava.version=1.4;-Djava.awt.headle+
ss=true;-Dos400.awt.native=true;') +
REPLACE(*YES)
When I try to run the XLCRTDEMO program I receive the following error.
Additional Message Information
Message ID . . . . . . : RNQ0301
Date sent . . . . . . : 09/02/17 Time sent . . . . . . : 15:16:41
Message . . . . : Java exception received when calling Java method (C G
D
F).
Cause . . . . . : RPG procedure XLCRTDEMO in program POI3.16/XLCRTDEMO
received Java exception "java.lang.NoClassDefFoundError:
org.apache.poi.hssf.usermodel.HSSFWorkbook" when calling method "<init>"
with signature "()V" in class
"org.apache.poi.hssf.usermodel.HSSFWorkbook".
Recovery . . . : Contact the person responsible for program maintenance
to
determine the cause of the problem.
Possible choices for replying to message . . . . . . . . . . . . . . . :
D -- Obtain RPG formatted dump.
S -- Obtain system dump.
G -- Continue processing at *GETIN.
Can someone help point me in the right direction because I am totally
lost.
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/java400-l.
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/java400-l.
midrange.com
