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