RE: some questions about java, RPG, Native driver for JDBC connec tion

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

Ashish

1)

When you use the JDBC driver, the library list used depends on the naming
format property
On your JDBC URL, if you use naming=sql, I think you just get the system
default library list
If you use naming=system, the library list is taken from the user profiles
job description.

If you want to set up a specific library list, you will need to append the
libraries to your URL
Eg

driverName=com.ibm.as400.access.AS400JDBCDriver
url=jdbc:as400://x.x.x.x;naming=system;date
format=eur;libraries=testdb,testpgm,*libl

Here I have a library list for a test environment that has the test
libraries at the top of the library list

Cheers
Colin.W

-----Original Message-----
From: Ashish Kulkarni [mailto:kulkarni_ash1312@xxxxxxxxx] 
Sent: 10 November 2003 01:47
To: java400-l@xxxxxxxxxxxx
Subject: some questions about java, RPG, Native driver for JDBC connection


Hi,
Here are some questions about calling Java from RPG
program.
1) Is it possible that the JDBC Connection have the
same library list of that the program calling and not
the library list set in the user profile ( job
description).
My problem is that there is no library list set on
user profile, and i want the Connection created using
the native driver in Java have the same library list
as that of the RPG program calling it?
2)If i have SETON LR in my RPG code do i still have to
tell java that u have finished using the objects
created in RPG program and destroy them?

3) If i have a method which has resultset as input
parameter, can i pass sql cursor from RPG while
calling this method? if so how
here is my java code
public String myMethod(ResultSet rs)
{
return someThing;
} 
This is my method declaration
d crtpdf          pr              o    extproc(*java: 
                    
d                                    
'com.pfizer.maps.data.CreatePdfForPO'
d                                      :'generatePDF')
                    
d                                    
class(*java:'java.lang.String')      
d input1                          o  
class(*java:'java.sql.ResultSet')    
d                                     const           
                    

but how do i pass cursor to this method??

Ashish

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
_______________________________________________
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.

For the latest on Bertram Books products and services and for up-to-the-minute 
book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential 
and privileged and is solely for the use of the intended recipient. If you are 
not the intended recipient please notify the sender and delete this e-mail and 
any attachments immediately