Re: XLPARSER4 open source tool for RPG -- RPG400-L

Looks like your classpath isn't set up properly.

Are there any instructions in the documentation stating the classpath to
use?

How about restoring specific Java files to the IFS?

Do you have any other Java applications running that may have already set
the classpath in your job before running this?

I'm sure Scott will provide more info when he gets time.

On Fri, Aug 31, 2018 at 2:48 PM Soucy, Michael <MSoucy@xxxxxxxxxxx> wrote:

Hi Bradley,

When I check the job log for the java error it says the following:

Message . . . . : Java exception received when calling Java method.

Cause . . . . . : RPG procedure XLPARSE_WO in program
XLPARSE36/XLPARSER4
received Java exception "java.lang.NoClassDefFoundError:

com.iseriesnetwork.clubtech.xlparse.ParseSheet" when calling method

"parse201003" with signature "([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').

I'm not really sure what this means. Am I missing a java component of
some kind?

Thank you,
Mike

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Bradley Stone
Sent: Friday, August 31, 2018 3:40 PM
To: RPG programming on the IBM i / System i
Subject: Re: XLPARSER4 open source tool for RPG

Michael,

There should be more detailed information in the job log. Can you look
for that? Especially the Java Exception error.

On Fri, Aug 31, 2018 at 2:18 PM Soucy, Michael <MSoucy@xxxxxxxxxxx> wrote:

I'm looking for some help with the Excel parsing tool written by Scott
Klement found here:

http://www.scottklement.com/poi/

I have downloaded and installed all the needed parts on my system.
When I attempt to run the sample program XLPDEMO it's giving me an
error. The error says:

Java exception received when calling Java method.
DSPLY Error occcured while parsing spreadsheet.

I'm not sure what it is I have done wrong. Does anyone have any
suggestions of how to debug my problem?

Michael Soucy
Sr. Programmer / Analyst
Community Health and Counseling Services
(207) 922-4837

****** CONFIDENTIALITY NOTICE ******

The documents accompanying this email contain confidential information
that may be legally privileged and protected by federal and state law.
This information is intended for use only by the entity or individual
to whom it is addressed. The authorized recipient is obligated to
maintain the information in a safe, secure, and confidential manner.
The authorized recipient is prohibited from using this information for
purposes other than intended, prohibited from disclosing this
information to any other party unless required to do so by law or
regulation, and is required to destroy the information after its stated

need has been fulfilled.

If you are in possession of this protected health information, and are
not the intended recipient, you are hereby notified that any improper
disclosure, copying, or distribution of the contents of this
information is strictly prohibited. Please notify the owner of this
information immediately and arrange for its return or destruction. Thank

You.

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD