I think we're getting closer now. I discovered that SQL2XLS was working
because it set the classpath to the location of the .jar file in the
IFS, whereas Scott's program expects it to be in the QIBM directory. So
I copied it to the QIBM directory, and now I've apparently moved on to a
new error. When I run Scott's program I actually get a spooled file
containing the following:
FATAL ERROR in native method: native code passed a null object to a
non-static method
java.lang.Throwable
I think we're making progress, because before I copied the .jar file, I
would run the QSHell command to show all the signatures for the HSSF
classes, and it wasn't able to find them. But after I copied the .jar
file to QIBM..., it found them OK.
G
|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
|bounces@xxxxxxxxxxxx] On Behalf Of Robert Rogerson
|Sent: Wednesday, November 28, 2007 4:53 PM
|To: RPG programming on the AS400 / iSeries
|Subject: RE: Java error when updating existing Excel spreadsheets using
|HS SF
|
|I had a similar problem (but I can't remember the exact message) but it
|was
|related on different versions of Java being started. It reared its
ugly
|head when I created a spreadsheet (with HSSF) and then attempted in
|email it
|(using RPGMail - an RPG wrapper for JavaMail). The problems were they
|were
|attempting to start different versions.
|Check procedure start_jvm in hssfr4.rpgle
|
|HTH,
|
|Rob
|
|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
|bounces@xxxxxxxxxxxx]
|On Behalf Of Fleming, Greg (ED)
|Sent: November 28, 2007 4:13 PM
|To: RPG programming on the AS400 / iSeries
|Subject: Java error when updating existing Excel spreadsheets using
HSSF
|
|Having read Scott Klement's excellent System iNetwork article on
|updating existing Excel spreadsheets using the apache POI HSSF api's,
|and the updated 2006 article aimed at fixing some Java errors some
folks
|were getting, I downloaded the revised 2006 source, created the service
|program and the sample program, and tried to run it, but I still get a
|java error (see details below).
|
|I'm sure the java classes are installed OK, because we also
successfully
|use Beppe Costagliola's SQL2XLS and SQL2JXL programs, which also use
the
|HSSF apis. I had also read a suggestion in the archives that the excel
|version newer than 2000 might cause trouble when updating existing
Excel
|sheets, so to eliminate that possibility I created an Excel document
|using SQL2XLS, then tried to update it using Scott's HSSFR4.
|
|Here's the error I get:
|
|Cause . . . . . : RPG procedure HSSF_OPEN in program GNODGDF/HSSFR4
|received Java exception "java.lang.NoClassDefFoundError:
|
|
| org/apache/poi/poifs/filesystem/POIFSFileSystem" when calling method
|"<init>" with signature "(Ljava.io.InputStream;)V" in class
|"org.apache.poi.poifs.filesystem.POIFSFileSystem".
|
|
|I also sent Scott an email through his website, but the auto-reply
|suggested posting here as he may be busy programming sausages, so
|hopefully someone else has already run into this problem and is just
|dying to share the solution.
|
|Thanks
|
|Greg Fleming
|
|Senior Programmer/Analyst
|
|Everglades Direct, Inc.
|
|--
|This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
|list
|To post a message email: RPG400-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
|or email: RPG400-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at
http://archive.midrange.com/rpg400-l.
|--
|This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
|list
|To post a message email: RPG400-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
|or email: RPG400-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at
http://archive.midrange.com/rpg400-l.
midrange.com
