Re: HSSFR4 - POI 3.6 - Java exception received whan call Java method "createCel​lStyle"

Hi Donnie,

Please consider using the putenv() API when you need to set an environment variable from RPG. It's much easier to use than ADDENVVAR (my opinion)

However, the error you posted doesn't appear to be related to your CLASSPATH. It says that you're trying to call an abstract method -- that implies that the workbook object that you're passing is an abstract object...

The information you posted is useful for troubleshooting a classpath problem or a java version mismatch problem -- but not for troubleshooting an abstract class problem. Can you show us the workbook object, and how you created it, and how you're calling the createCellStyle method of it?

Thanks!



On 7/10/2012 5:41 PM, Donnie wrote:

All,



I've created several programs that use HSSFR4 and POI 3.6 on our V6R1 box
and they work fine.



Next I copied the same programs, jar files, etc... to a V5R4 box and am
getting the folllowing error message:



Additional Message
Information


Message ID . . . . . . : RNX0301 Severity . . . . . . . :
50
Message type . . . . . :
Escape
Date sent . . . . . . : 07/10/12 Time sent . . . . . . :
12:54:00


Message . . . . : Java exception received when calling Java
method.
Cause . . . . . : RPG procedure CREATECELL in program
xxxPGMS/xxx990POI
received Java exception
"java.lang.AbstractMethodError:
org/apache/poi/ss/usermodel/Workbook.createCellStyle()Lorg/apache/poi"
when
calling method "createCellStyle" with
signature
"()Lorg.apache.poi.ss.usermodel.CellStyle;" in
class

"org.apache.poi.ss.usermodel.Workbook".

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





Here are some of the installed licensed programs on the V5R4 box:



Display Installed Licensed Programs

Licensed Product
Program Option Description

5722JV1 *BASE IBM Developer Kit for Java

5722JV1 5 Java Developer Kit 1.3
5722JV1 6 Java Developer Kit 1.4
5722JV1 7 Java Developer Kit 5.0
5722JV1 8 J2SE 5.0 32 bit

5722WDS 31 ILE RPG

5722SS1 13 System Openness Includes





Here's how I have the environment variables setup:




// Classpath


rtnCode# = ExecSysCMD('ADDENVVARENVVAR(CLASSPATH) ' +

'VALUE(''/java/poi3.6/poi-3.6-20091214.jar:/java' +

'/poi3.6/poi-ooxml-3.6-20091214.jar:/java' +

'/poi3.6/poi-ooxml-schemas-3.6-20091214.jar:'+

'/java/dom4j/dom4j-1.6.1.jar:/java/xmlbeans/'+

'jsr173_1.0_api.jar:/java/xmlbeans/xbean.jar'+

''') LEVEL(*JOB) REPLACE(*YES)');

// QIBM_RPG_JAVA_PROPERTIES

rtnCode# = ExecSysCMD('ADDENVVARENVVAR(QIBM_RPG_JAVA_PROPERTIES)
' +

'VALUE(''-Djava.awt.headless=true;-Dos400.awt.native=true;'+

''') LEVEL(*JOB) REPLACE(*YES)');

// JAVA_HOME

rtnCode# = ExecSysCMD('ADDENVVARENVVAR(JAVA_HOME) ' +

'VALUE(''/QOpenSys/QIBM/ProdData/JavaVM/jdk50/32bit'+

''') LEVEL(*JOB) REPLACE(*YES)');

// QIBM_JAVA_PROPERTIES_FILE

rtnCode# =
ExecSysCMD('ADDENVVARENVVAR(QIBM_JAVA_PROPERTIES_FILE) '+

'VALUE(''/QIBM/UserData/Java400/JDK15SystemDefault.properties'+

''') LEVEL(*JOB) REPLACE(*YES)');

endif;





Since I don't fully understand the problem, I don't know what other
information to provide for further analysis. Any ideas?



Thanks,

Donnie