Re: STRDBG/ENDDBG required to prevent Java open exception -- MIDRANGE-L

Hi Leif,

Thanks. I'm no Java programmer, but that looks a lot like what Scott Khas in his service program, although with some error handling. I don'tknow that it's any easier or better a solution than the simplestrdbg/enddbg though. And it doesn't really explain what the problemis; it's just another way around it.

I have noticed that if I don't do the strdbg/enddbg, but simply call theprogram again after the error has occurred, it works fine. Which makesit sound like something in the JVM gets initialized after the firstcall, so that it works the 2nd time.


*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Leif Guldbrand wrote:

Sorry Peter,

Seem the link I gave you goes to nowhere.....


Here's the hole thing in text (thanks to Marco):

Hey all,
Just thought I'd let you know that I was able to work my way around thisproblem...thanks to David Hinselwood...I saw that he'd had a similarproblem back in the day and contacted him to see if he had ever resolvedit...he said that he created his own java program to open the spreadsheetinstead of having RPG do it...here's his java program:
XLWorkBook.java
import java.io.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class XLWorkBook {
   static public HSSFWorkbook loadWB(String fileName) {
      POIFSFileSystem fs = null;
      HSSFWorkbook wb = null;
      FileInputStream infile = null;
      try {
         infile = new FileInputStream(fileName);
         fs = new POIFSFileSystem(infile);
         wb = new HSSFWorkbook(fs);
         infile.close();
      }
      catch (IOException e) {
         e.printStackTrace();
      }
      finally {
         if (infile != null) {
            try {
               infile.close();
            }
            catch (IOException e) {
               e.printStackTrace();
            }
         }
      }
   return wb;
 }
}
place this java program in the same IFS folder as the Jakarta POI jarfiles...change your current directory on the iSeries using CHGCURDIRDIR('/QIBM/UserData/Java400/ext/')...or wherever your POI files are...thencompile the java program using STRQSH...in there execute the followingcommand...javac /QIBM/UserData/Java400/ext/XLWorkBook.java...this willcreate your class for use in your RPGLE programs...
then, in my RPGLE program:

d openXL          pr              o   extproc(*JAVA
d                                     :'XLWorkBook'
d                                     :'loadWB')
d                                     CLASS(*JAVA:
d                                     'org.apache.poi.hssf.usermodel-
d                                     .HSSFWorkbook')
d                                     static
d  fileName                           like(jString)
...
d fileName        s                   like(jString)
...
fileName = new_String('/home/scessna/excel/May05DailyLaborHours.xls');
book = openXL(fileName);

hope this helps anyone else who was/is having the same problem as me...
Leif