RE: HSSFR4 - POI 3.6 - Java exception received ehan call Java method "createCellStyle"

[Mike Krebs <mkrebs@xxxxxxxxxxxxxxxxxx>]

Hi Donnie, I don't usually understand this stuff either. 
But you will get better response from midrange.com. Scott monitors those lists as well.
This list is for FTPAPI and HTTPAPI related questions.

-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Donnie
Sent: Tuesday, July 10, 2012 12:40 PM
To: ftpapi@xxxxxxxxxxxxxxxxxxxxxx
Subject: HSSFR4 - POI 3.6 - Java exception received ehan call Java method "createCellStyle"

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('ADDENVVAR ENVVAR(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('ADDENVVAR
ENVVAR(QIBM_RPG_JAVA_PROPERTIES) ' +

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

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

           // JAVA_HOME

           rtnCode# = ExecSysCMD('ADDENVVAR ENVVAR(JAVA_HOME) ' +

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

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

           // QIBM_JAVA_PROPERTIES_FILE

           rtnCode# = ExecSysCMD('ADDENVVAR
ENVVAR(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
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------