There is a readme file with the source code. The readme talks about how to upload, compile, and run the sample program. There is no mention of setting up the classpath in the readme file. Unfortunately all the links to the related material on Scott's website are broken. They all point to the systeminetwork.com website.

Per the readme file I put the two jar files it said to place in the /Java folder on the IFS. I'm not sure if I need to specify both files in the classpath or just one. If it's just one, which one is it. The jar files it says to place in the IFS are:

xlparse-src.jar
xlparse.jar

I've implemented Scott's JDBC4 utility on my system and that works like a charm. It requires you to setup the classparth for the JDBC drivers you are using. I setup the classpaths for both SQL Server and Sybase and they work great.

Something to maybe tackle on Tuesday.

Mike

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

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

--
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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].