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

Hi,
thanx i am going to use this so can get rid of passing
library from RPG to Java

good solution, just have to consider all the library
names for parsing to get the correct library list

Ashish
--- Marc Nothum <Marc_Nothum@xxxxxx> wrote:
> 
> 
> 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.
> 
> 
> 
> 
> 
> _______________________________________________
> 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/