Re: POI, HSSFR4 and Debug

Marco,

I went the Java way (XLWorkBook.java). 
Though receiving 3 errors running javac, 
it seem that openXL is working.

Best regards,
Leif
----- Original Message ----- 
From: "Marco Facchinetti" <facchinetti@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: 11. maj 2006 08:53
Subject: Re: POI, HSSFR4 and Debug


> Thanks for the answer Leif, since I'm still reading the flood of answers I
> think I'm going to follow tha Java way...
> 
> Marco
> 
> --- Leif Guldbrand <Guldbrand@xxxxxxxxx> wrote:
> 
> > Marco,
> > 
> > Your not alone with this problem. I have exact the same problem, but
> > because
> > my 7 programs (7 different spreadsheets) will only be needed once in
> > production
> > I fire up the debug and run the programs without any troubles.
> > 
> > But what bothers me.... late in 2005 I developed another application
> > taking data
> > from a spreadsheet up in a workfile in QSYS. Adding data from files in
> > QSYS to 
> > that workfile and then updated the spreadsheet with new data.
> > 
> > This application has been running every day since it went in production,
> > and it have
> > never failed.
> > 
> > Best regards,
> > Leif
> > ----- Original Message ----- 
> > From: "Marco Facchinetti" <facchinetti@xxxxxxxxx>
> > To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> > Sent: 10. maj 2006 12:23
> > Subject: POI, HSSFR4 and Debug
> > 
> > 
> > > Hi, I wrote a simple program to read an Excel file, modify some cells
> > and
> > > 
> > > write back on the Ifs. Of course, since I'm an rpg programmer, I used
> > the
> > > service program provided by Scott Klement (HSSFR4).
> > > 
> > > The problem is when I run the pgm from the command line I've got an
> > error 
> > > 
> > > Message . . . . :   Java exception received when calling Java method.
> > > Cause . . . . . :   RPG procedure HSSF_OPEN in program xlib/HSSFR4
> > received
> > > Java exception "java.io.IOException:" when calling method 
> > > "<init>" with signature "(Ljava.io.InputStream;)V" in class
> > > "org.apache.poi.poifs.filesystem.POIFSFileSystem".
> > > 
> > > If I call the same program using the debug (STRDBG PGM(LE36)
> > UPDPROD(*YES)
> > > SRVPGM(HSSFR4)) it's working perfectly.
> > > 
> > > POI .jar files are in /QIBM/UserData/Java400/ext.
> > > 
> > > Any hint, idea or...
> > > 
> > > Thanks in advance
> > > 
> > > Marco
> > > 
> > > P.S. I saw the thread in:
> > > http://archive.midrange.com/java400-l/200505/msg00133.html
> > > but he ended up writing Java code to fix the problem.