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

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hi Szabolcs,

    Are you sure the JDBC solution is too slow?  By that I mean have you
tried optimizing the process by changing the fetch size, using batch updates
and so on?  Prepared statements should almost always be preferred over a
plain Statement.

    JDBC ( and its relatives in other languages ) are not optimal for mass
data import/updates, but when you are dealing with two distinct RDBMS
engines, other solutions are going to involve intermediate copies and
program calls, so you may not see much performance difference.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Szabolcs Pall" <spall@xxxxxxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Tuesday, March 22, 2005 1:16 PM
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
> --