I have meanwhile discovered it was (probably) an activation group and/or binding directory problem.
My compile command didn't contain 'ACTGRP(XLPARSE) BNDDIR(QC2LE)'.
I added it and now it's working, albeit only for .xlsx files.
If I run my program for an .xls file, I get a java error:
Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 26/11/14 Time sent . . . . . . : 06:10:15
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure XLPARSE_WO in program XLPARSE36/XLPARSER4
received Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/record/SSTRecord.getString(I)Lorg/apache/poi/hssf/r"
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').
Even though I could live with having to convert all files we need to process to .xlsx, it would be nice if the service program were backward compatible.
Any clues?
Met vriendelijke groeten / Best regards,
Peter Colpaert
Software Engineer - PLM Development Team
IT Operations Cluster Benelux, Philips IT
Philips Consumer Luminaires
Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel: (+32) 3/459 13 17
Email: Peter.Colpaert@xxxxxxxxxxx
Working from home on Wednesdays
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Sam_L
Sent: dinsdag 25 november 2014 18:32
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: XLPARSER4 question
Fiddling with the library list (removing the library with the old > *SRVPGM, adding the one with the new version on top) doesn't solve anything.
Maybe a hard coded library name somewhere? Perhaps in the binding directory?
Sam
On 11/24/2014 11:29 PM, Colpaert, Peter wrote:
This is what I see on my program:
Service
Program Library Activation Signature
XLPARSER4 XLPARSE36 *IMMED E7D3D7C1D9E2C5D9F4E5F0F1F0F0F0F0
And in the binding directory:
Object Type Library Activation Date Time
XLPARSER4 *SRVPGM XLPARSE36 *IMMED 24/11/14 08:50:31
So it would seem that this is ok.
Met vriendelijke groeten / Best regards,
Peter Colpaert
Software Engineer - PLM Development Team IT Operations Cluster
Benelux, Philips IT
Philips Consumer Luminaires
Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel: (+32) 3/459 13 17
Email: Peter.Colpaert@xxxxxxxxxxx
Working from home on Wednesdays
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
--
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:
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.
________________________________
The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.
midrange.com
