RE: Pass ResultSet / Array of Strings from Java to AS400 StoredProcedure

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Like others, I'm confused at to where the various pieces are.  You retrieve a 
result set from Oracle, to what? The 400 or another PC.  Now you want Oracle to 
update the 400 or this other PC?

In any event, no, you can't pass a result set to a stored procedure.

Your data queue idea would be a good solution.

Another idea would be to build a temporary table on the 400, make sure to use a 
blocked insert!.  Then call a stored proc on the 400 to process the temporary 
table, updating the table you wanted updated.


HTH,

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Szabolcs Pall
> Sent: Tuesday, March 22, 2005 1:17 PM
> To: java400-l@xxxxxxxxxxxx
> Subject: Pass ResultSet / Array of Strings from Java to AS400
> StoredProcedure
> 
> 
> Hi,
> 
> I have some data in Oracle that I retrieve using JDBC, and 
> then want to 
> step through the resultset, updating an AS400 Physical File. 
> The resultset 
> has about 10,000 records... so Statement and 
> PreparedStatement are way too 
> slow.
> 
> I want to use CallableStatement but I don't know how to get 
> my resultset 
> to the AS400 stored procedure. Can I pass a Java Resultset to 
> an AS400 
> Stored Procedure?
> 
> I've thought about dumping the data from Oracle into a 
> data-queue, and 
> then having an RPG program read the data and update the 
> file... are there 
> any other workarounds if I can't pass ResultSets to prepared 
> statements?
> 
> Thanks,
> Szabolcs
> -- 
> 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.
> 
>