Re: POI, HSSFR4 and Debug

[Marco Facchinetti <facchinetti@xxxxxxxxx>]

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.
> 
> 
> 
> -- 
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com