Four Js Development Tools Forum

Hello,

Trying using POI 5.2.3 ...

With POI 5.1.0 no problems but with 5.2.3 and this CLASSPATH (see below) fglcomp errors -6222 on IMPORT JAVA statements
Any fglcomp hidden switch to trace java dependencies ?

Any help appreciated

Thank you



export POI_HOME=/opt/poi-5.2.3
export CLASSPATH=$POI_HOME/poi-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-examples-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-excelant-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-javadoc-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-ooxml-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-ooxml-full-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-ooxml-lite-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/poi-scratchpad-5.2.3.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/commons-codec-1.15.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/commons-collections4-4.4.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/commons-io-2.11.0.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/commons-math3-3.6.1.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/log4j-api-2.18.0.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/lib/SparseBitSet-1.2.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/commons-compress-1.21.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/commons-logging-1.2.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/curvesapi-1.07.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/jakarta.activation-2.0.1.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/jakarta.xml.bind-api-3.0.1.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/slf4j-api-1.7.36.jar
export CLASSPATH=$CLASSPATH:$POI_HOME/ooxml-lib/xmlbeans-5.1.1.jar
export CLASSPATH=$CLASSPATH:/opt/log4j-2.18.0/log4j-api-2.18.0.jar
export CLASSPATH=$CLASSPATH:/opt/log4j-2.18.0/log4j-core-2.18.0.jar

Hello Benjamin,

this is my current config for Java 11/POI 5.2.3 defined in the Genero configuration and runs fine.

JAVA_HOME=/usr/lib/jvm/java-11-openjdk-11.0.18.0.10-1.el7_9.x86_64/
JRE_HOME=/usr/lib/jvm/java-11-openjdk-11.0.18.0.10-1.el7_9.x86_64/

POI_HOME=/usr/local/src/poi-bin-5.2.3
LOG4J_HOME=/usr/local/src/apache-log4j-2.17.1-bin

CLASSPATH=$(POI_HOME)/poi-5.2.3.jar;
          $(POI_HOME)/poi-ooxml-5.2.3.jar;
          $(POI_HOME)/poi-ooxml-full-5.2.3.jar;
          $(POI_HOME)/lib/commons-codec-1.15.jar;
          $(POI_HOME)/lib/commons-collections4-4.4.jar;
          $(POI_HOME)/lib/commons-io-2.11.0.jar;
          $(POI_HOME)/lib/commons-math3-3.6.1.jar;
          $(POI_HOME)/lib/log4j-api-2.18.0.jar;
          $(POI_HOME)/lib/SparseBitSet-1.2.jar;
          $(POI_HOME)/ooxml-lib/commons-compress-1.21.jar;
          $(POI_HOME)/ooxml-lib/commons-logging-1.2.jar;
          $(POI_HOME)/ooxml-lib/curvesapi-1.07.jar;
          $(POI_HOME)/ooxml-lib/slf4j-api-1.7.36.jar;
          $(POI_HOME)/ooxml-lib/xmlbeans-5.1.1.jar;
          $(POI_HOME)/ooxml-lib/jakarta.activation-2.0.1.jar;
          $(POI_HOME)/ooxml-lib/jakarta.xml.bind-api-3.0.1.jar;
          $(LOG4J_HOME)/log4j-core-2.19.0.jar;
          $(LOG4J_HOME)/log4j-api-2.19.0.jar;
          $(CLASSPATH)

Kind regards
Roland

Hi,

thanks for the response but same problem with  your classpath ...

my version is :

fglcomp 4.01.01 rev-f4262d03
Genero 4gl compiler
Target l64xl217

and

openjdk 11.0.18 2023-01-17
OpenJDK Runtime Environment (build 11.0.18+10-post-Debian-1deb10u1)
OpenJDK 64-Bit Server VM (build 11.0.18+10-post-Debian-1deb10u1, mixed mode, sharing)

have tried with strace but nothing relevant for me

Regards

also strange in your config there is a mismatch version between path of LOG4J_HOME (version 2.17.1) and log4j- jar files (version 2.19.0)

LOG4J_HOME=/usr/local/src/apache-log4j-2.17.1-bin

CLASSPATH=...    $(LOG4J_HOME)/log4j-core-2.19.0.jar;          $(LOG4J_HOME)/log4j-api-2.19.0.jar;

regards

Hi,

I let you check the "Resolution Comment" field for
#FGL-05823 (https://4js.com/support/issue/?id=FGL-05823&redir=true) - Compiler error with IMPORT JAVA but similar pure Java code compiles.

If you still cannot find the issue, please contact your local support center.

Best regards,
Sisa.

Benjamin,

you're right. I forgot to adjust the path for LOG4J after upgrading to version 2.19.0.
The environment for LOG4J is now correct:

LOG4J_HOME=/usr/local/src/apache-log4j-2.19.0-bin

Kind regards
Roland

Hi,

Finally found the issue, file poi-5.2.3.jar was corrupted (bad EOF ...)

Thanks