SS_OPEN not working in Java 8

Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Post Reply
Bill P
Posts: 2
Joined: Mon Apr 07, 2025 5:58 pm

SS_OPEN not working in Java 8

Post by Bill P »

We are upgrading our system from 7.2 to 7.4. We are using Java 6 on 7.2 which is not supported on 7.4. When we update the java path to Java 8 the SS_OPEN fails using HSSF to open excel an excel file. This works fine with Java 6 but fails with Java 8.

We tried updating the poi classes also.

The original class path was set to:

:/java/poi3.9/poi-ooxml-3.9-20121203.jar+
:/java/poi3.9/poi-ooxml-schemas-3.9-20121203.jar+
:/java/dom4j/dom4j-1.6.1.jar+
:/java/xmlbeans/jsr173_1.0_api.jar+
:/java/xmlbeans/xbean.jar'

We have updated this to:

:/java/poi-3.8/poi-3.8-20120326.jar+
:/java/poi-3.8/poi-ooxml-3.14-20120326.jar+
:/java/poi-3.8/poi-ooxml-schemas-3.14-20120326.jar+
:/java/poi-3.8/lib/commons-logging-1.1.jar+
:/java/poi-3.8/lib/log4j-1.2.13.jar+
:/java/poi-3.8/ooxml-lib/xmlbeans-2.3.0.jar+


No matter what we try the open still fails with Java 8 with this error.

Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 04/07/25 Time sent . . . . . . : 14:21:02

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure SS_OPEN in program HSSF/HSSFR4 received Java
exception "java.io.FileNotFoundException: Invalid file path" when calling
method "<init>" with signature "(Ljava.lang.String;)V" in class
"java.io.FileInputStream".
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


Any assistance would be greatly appreciated.
Bill P
Posts: 2
Joined: Mon Apr 07, 2025 5:58 pm

Re: SS_OPEN not working in Java 8

Post by Bill P »

Resolved:

Found this on google, someone else had a similar issue:
Java8.jpg
Java8.jpg (83.05 KiB) Viewed 13694 times
Post Reply