Re: Jakarta POI HSSF question...

[Shane_Cessna@xxxxxxx]

WOO HOO!!! ok, now we're getting somewhere...I added the envvar 
QIBM_RPG_JAVA_EXCP_TRACE with a value of 'Y' and QIBM_RPG_JAVA_PROPERTIES 
VALUE('-Dos400.stderr=file:stderr.txt;')...and it gave me my stderr.txt 
file...here's what it says...

java.io.IOException  
      java/lang/Throwable.<init>()V+4 (Throwable.java:73)  
      java/lang/Exception.<init>()V+1 (Exception.java:24)  
      java/io/IOException.<init>()V+1 (IOException.java:26)  
      java/io/FileInputStream.read([BII)I+1 (FileInputStream.java:179)   
      org/apache/poi/util/IOUtils.readFully(Ljava/io/InputStream;[BII)I+13 
(IOUtils.java:51)
      org/apache/poi/util/IOUtils.readFully(Ljava/io/InputStream;[B)I+5 
(IOUtils.java:36)
 
org/apache/poi/poifs/storage/HeaderBlockReader.<init>(Ljava/io/InputStream;)V+18
 
(HeaderBlockReader.java:71)
 
org/apache/poi/poifs/filesystem/POIFSFileSystem.<init>(Ljava/io/InputStream;)V+9
 
(POIFSFileSystem.java:83)

just for reference, here's what my job log says...

Message . . . . :   Java exception received when calling Java method.  
Cause . . . . . :   RPG procedure HSSF_OPEN in program ASCLIB/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". Recovery  . . . :  
  Contact the person responsible for program maintenance to determine the  
 
  cause of the problem. Technical description . . . . . . . . :   If the   

  exception indicates that the Java class was not found, ensure the class 
for 
  the method is in the class path. If the exception indicates that the 
Java 
  method was not found, check the method name and signature. If the 
signature 
  is not correct, change the RPG prototype for the method, or change the 
Java 
  method, so that the return type and parameter types match. You can 
determine
  the signatures for all the methods in class XYZ using command QSH 
CMD('javap
  -s XYZ').


Shane Cessna  
iSeries Programmer
iSeries WAS Administrator
North American Lighting, Inc.
(618) 662-4483 x2776
shane_cessna@xxxxxxx 



Barbara Morris <bmorris@xxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
05/27/2005 06:06 PM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
java400-l@xxxxxxxxxxxx
cc

Subject
Re: Jakarta POI HSSF question...






Shane_Cessna@xxxxxxx wrote:
> ...
> if someone could help me out on how I can get this stack trace, that'd 
be
> great...I don't know a whole lot about java, so trying to use this in an
> RPGLE program is quite a challenge for me...

If you're on V5R3, you can get the RPG runtime to do a stack trace by
having environment variable QIBM_RPG_JAVA_EXCP_TRACE set to a value of
'Y'.  You'll probably also need to have your stderr go to an IFS file
(see the link below for how to do that), although in batch it might
automatically go to a QPRINT spool file, I'm not sure.

If you're not on V5R3, here is a not-so-easy way to get a stack trace (a
different Java method from yours, but the principle is the same):
http://archive.midrange.com/rpg400-l/200402/msg00301.html