Re: Java error in XLPARSER4 while reading a formula field

Dear scott

Can you guide me how to set the CLASSPATH suppose I'm having all poi and xlparse.jar files in /chamara/java




Regards,

Chamara Withanachchi
Owner of www.rpgiv.info

WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info



Sent from my BlackBerry® wireless device

-----Original Message-----
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>

Date: Wed, 07 Jan 2009 05:51:46
To: RPG programming on the IBM i / System i<rpg400-l@xxxxxxxxxxxx>
Subject: Re: Java error in XLPARSER4 while reading a formula field


This implies that it can't find the xlparse.jar file, either. I thought
you said that this part was working, already?


Chamara Withanachchi wrote:

Dear Scott,

Additional Message
Information


Message ID . . . . . . : RNX0301 Severity . . . . . . . :
50
Message type . . . . . :
Escape
Date sent . . . . . . : 07/01/09 Time sent . . . . . . :
14:40:49


Message . . . . : Java exception received when calling Java
method.
Cause . . . . . : RPG procedure XLPARSE_WO in program
CHAMARA/XLPARSER4
received Java exception
"java.lang.NoClassDefFoundError:
com/iseriesnetwork/clubtech/xlparse/ParseSheet" when calling method
"parse"
with signature "([B[B[B)V" in
class

"com.iseriesnetwork.clubtech.xlparse.ParseSheet".

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
type and parameter types match. You can determine the signatures for all the
methods in class XYZ using command QSH CMD('javap -s XYZ').



--
Regards,


Chamara Withanachchi
Owner of www.rpgiv.info

WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info


On Wed, Jan 7, 2009 at 2:30 PM, Chamara Withanachchi <chamaraw@xxxxxxxxxx>wrote:

Dear Scott,

Can you send me your POI Class (.JAR Files) so i can upload same to my
server and test. also send me the xlparse.jar file. So i can test it.


--
Regards,


Chamara Withanachchi
Owner of www.rpgiv.info

WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info

On Wed, Jan 7, 2009 at 1:15 PM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>wrote:

No! As I said in my last message, any binary-safe file transfer method
should be fine. (I assume Ops Nav is binary-safe, though I must admit
that I have little exposure to using it for file transfer.)

I guess I don't know what else to suggest... the fact that it works
fine for other excel files, and only fails for formulas has me a bit
stumped. That would imply that you have most/all of the POI classes,
but are missing the CellReference class -- and I don't understand why
you'd be missing just that one class.

So I'm not sure what else to suggest... I can tell you, however, that
I'm able to read a formula without receiving this error... so why can
my computer find that class and not yours? I wish I knew!

Chamara Withanachchi wrote:

I'm Using both POI and xlparse.jar for normal excel file reads when I

tried

to read excel with a formula field this error occurred. I have plased

all

JAR files by using Operations navigator, is it a must that I should use

FTP

in BIN mode?

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.