Re: Starting off with POI/HSSF

If you have the 32-bit version of Java 5 installed you can add this
environment variable to enable it for your job.

ADDENVVAR ENVVAR(JAVA_HOME)
VALUE('/QOpenSys/QIBM/ProdData/JavaVM/jdk50/32bit')

Make sure your classpath variable is CLASSPATH (all caps). You
probably don't need the scratchpad JAR or the contribute JAR either.
Also you should be using the absolute path to the JAR files. So it
should be ".:/home/FOXWELL/java/jars/POI-3.0.1-FINAL-20070705.JAR".
Currently you have each JAR with a / (path separator) at the start of
each file name which tells the ClassLoader to look in the root (/)
directory for the JAR.

Just a general note a the classpath too. It's best to always add a .
(dot) to your classpath, I usually put it in the beginning of the
string. That allows you to run Java classes from your current
directory.

One common misunderstanding, I've had it too, is that if you give a
generic path to a directory containing libraries (JAR's) that each one
will be loaded in the classpath. You have to explicitly indicate which
JAR's you want in your classpath. Now I know there are ways around
this using custom ClassLoaders and various other ways, but explicitly
defining them in your classpath is much simpler.

--
James R. Perkins


On Tue, Feb 2, 2010 at 00:58, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:

Ok thanks all.

 Installed the older poi 3.0.1 as I don't see how to get the
 JVM version. By the way, apparently it's possible to indicate
 which version of JVM to use with a parameter if several
 versions are installed. Anyone know that syntax?

 Now my problem seems to be CLASSPATH as I'm getting a class
 not found error.

 Here's my classpath value :
 Value . . . . . . . . . :
 '/home/FOXWELL/java/jars:/POI-3.0.1-FINAL-20070705.
 JAR:/POI-CONTRIB-3.0.1-FINAL-20070705.JAR:/POI-SCRATCHPAD-3.0.
1-FINAL-20070705.J
 AR:.'



 I'm not sure about this. My current directory when I sign on
 is /home/FOXWELL. Can someone indicate if I have the right CLASSPATH?

-----Message d'origine-----
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de

Scott Klement

Envoyé : mardi 26 janvier 2010 18:52 À : Midrange Systems Technical
Discussion Objet : Re: Starting off with POI/HSSF

Hi David,

It appears that you are using a version of Java that's too

old for the

version of POI that you downloaded.   (That's what
UnsupportedClassVersionError means)

Either use a newer JVM or an older POI jar.

-SK


On 1/26/2010 6:56 AM, David FOXWELL wrote:

Hi, I've installed poi-3.6-20091214.jar and hssfr4.rpgle

dated 10/7/2007 and getting a compatibility error :

Cause . . . . . : La procédure RPG XLCRTDEMO du programme

FOXWELL/XLCRTDEMO a

   reçu une erreur Java "java.lang.UnsupportedClassVersionError:
   org/apache/poi/hssf/usermodel/HSSFWorkbook" en appelant

la méthode "<ini"

   avec la signature "" dans la classe
   "org.apache.poi.hssf.usermodel.HSSFWorkbook".

Is it the version of JAVA on the i or the wrong version of

hssfr4.rpgle? How do I check?

Thanks.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,

please take

a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.