Re: poi nosuchmethoderror

Eric,

RPG procedure CRPGPROC (this is likely an RPG routine that someone in your shop wrote -- or something you got from a vendor?) is trying to call a Java method (similar in concept to a subprocedure) named getSheetAt.

It is expecting that method to accept an integer as a parameter (I), and it is expecting it to return a Java object of a particular class (the class.name got cut off in the message, but starts with "org/apache/poi/ss/usermodel.SHEET")

Can you look at CRPGPROC and see what's going on?   The fact that "SHEET" is in all capital letters seems VERY VERY suspicious to me... I'm thinking someone changed it to uppercase when it was meant to be mixed case.  Also, verify that the prototype for getSheetAt is written correctly, check its parameters, return value, et al, against the documentation for the POI version you're working with.

Just a little bit of looking around and troubleshooting should make it easy to solve a problem like this.

-SK



On 9/6/23 11:35 AM, eric bothes wrote:

getting the following and not sure why. the path looks correct and the jar file has the class workbook with a method getsheetat.

Message . . . . :   Java exception received when calling Java method.
Cause . . . . . :   RPG procedure CRPGPROC in program DONNA/PRCFILES received
  Java exception "java.lang.NoSuchMethodError:
org/apache/poi/ss/usermodel/Workbook.getSheetAt(I)Lorg/apache/poi/ss/us"
  when calling method "getSheetAt" with signature
  "(I)Lorg.apache.poi.ss.usermodel.SHEET;" in class
  "org.apache.poi.ss.usermodel.Workbook".


os: 7.1
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap6460_26sr5ifix-20130304_01(SR5+IV37419))
IBM J9 VM (build 2.6, JRE 1.6.0 OS/400 ppc64-64 Compressed References jvmap6460_26sr5-20130207_01_cr (JIT enabled, AOT enabled)
J9VM - R26_Java626_SR5_20130204_0851_B137148
JIT  - r11.b03_20130131_32403
GC   - R26_Java626_SR5_20130204_0851_B137148_CMPRSS
J9CL - 20130204_137148)
JCL  - 20130303_02

classpath:

/home/donna/poi/poi.jar:
/home/donna/poi/poi-ooxml.jar:
/home/donna/poi/dom4j.jar:
/home/donna/poi/xbean.jar:
/home/donna/poi/jsr.jar:
/home/donna/poi/poi-ooxml-schemas.jar:
/home/donna/poi/poi-scratchpad.jar

jar files:
/home/donna/poi/dom4j.jar
/home/donna/poi/jsr.jar
/home/donna/poi/poi.jar
/home/donna/poi/poi-ooxml-schemas.jar
/home/donna/poi/poi-scratchpad.jar
/home/donna/poi/xbean.jar

code:
d SSWORKBOOK_GETSHEETAT...
d                 pr                  LIKE(SSSheet)
d                                     EXTPROC(*JAVA:WORKBOOK_CLASS
d                                     :'getSheetAt')
d SHEETIDX                            LIKE(JINT) VALUE

d WORKBOOK_CLASS  c 'org.apache.poi.ss.usermodel.-
d Workbook'

SSWorkbook=ss_open(%trim(filename));                  --- works fine. pointer not null.
SSSheet = SsWorkbook_getSheetAt(SSWorkbook : 0  );   --- bombs