RE: How to call java method from RPG which has ResultSet as input parameter

Hi,

I use the following java-code, to retrieve the libl, that is in place for
the current job:

Properties prop = System.getProperties();
String libListForm1 = prop.getProperty("java.library.path");

Then I do some parsing, to convert it to the format that has to be used for
the JDBC-library-list property.


Regards,

      Marc Nothum







Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>@midrange.com on 21/11/2003
19:36:25

Please respond to Java Programming on and around the iSeries / AS400
       <java400-l@xxxxxxxxxxxx>

Sent by:    java400-l-bounces@xxxxxxxxxxxx


To:    Java Programming on and around the iSeries/AS400
       <java400-l@xxxxxxxxxxxx>
cc:

Subject:    RE: How to call java method from RPG which has ResultSet as
       input      parameter


Hi
I figured that i wont be able to pass result set to
java program from RPG, and so what i am doing is
passing a library list to java program from RPG which
i use to in JDBC properties while creating my
connection.
But this is kind of hardcoding as i cannot chnage the
library list on fly, unless i keep it in some data
area or configuration file, and change it when user is
using different set of libraris..
but anyway have to live with it for now

Ashish
--- "McCallion, Martin" <martin.mccallion@xxxxxxxxx>
wrote:
> RPG has no concept of ResultSet.  I don't think an
> SQL cursor is the
> same thing, so even if you could somehow pass it to
> the Java class, it
> wouldn't be what the class was expecting.  Barbara's
> suggestion was a
> way to give you a result set object within an RPG
> program; still,
> though, you wouldn't be able to do much with it in
> the RPG, except pass
> it on to another Java class.
>
> I think you are trying to do incompatible things,
> really.  However, your
> real problem appears to be the library list one, so
> that's probably the
> one you should try to address.
>
> > I am trying to do this because when i create a
> JDBC
> > connection in java program it uses the library
> list of
> > the user job description and not of the Job which
> is
> > calling it, in other words if the Library is LIB1
> in
> > the job which is calling it, and if in user job
> > description of user profile if the Library is
> LIB2,
> > then the connection as LIB2 instead of LIB1
>
> Part of the JDBC connection string is "database"
> which is a library in
> iSeries terms:
> jdbc:as400://iSeries-name/database-name.
>
> Plus the IBM JDBC drivers have an optional parameter
> for "libraries"
> which, if I recall correctly, allows you to specify
> a comma-separated
> list of libraries.  The Connection should, I
> believe, treat it similarly
> to a library list.
>
> HTH.
>
> Cheers,
>
> Martin.
>
> --
> Martin McCallion
> Senior Technical Consultant
> Misys Wholesale Banking Systems
> 1 St George's Road, London, SW19 4DR, UK
> T +44 (0)20 8486 1951
> F +44 (0) 20 8947 3373
> martin.mccallion@xxxxxxxxx
> www.misys.com
>
> This email and any attachments have been scanned for
> known viruses using
> multiple scanners. We believe that this email and
> any attachments are
> virus free, however the recipient must take full
> responsibility for
> virus checking. This email message is intended for
> the named recipient
> only. It may be privileged and/or confidential. If
> you are not the
> intended named recipient of this email then you
> should not copy it or
> use it for any purpose, nor disclose its contents to
> any other person.
> You should contact the Misys Banking and Securities
> Division as shown
> below so that we can take appropriate action at no
> cost to yourself.
>
> Misys Banking and Securities Division, 1 St George's
> Road, Wimbledon,
> London, SW19 4DR, England. Email:
> banking.postmaster@xxxxxxxxxx Tel: +44
> (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
> _______________________________________________
> 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.
>


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
_______________________________________________
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.