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

["McCallion, Martin" <martin.mccallion@xxxxxxxxx>]

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