RE: Passing Java Object to iSeries -- JAVA400-L

Hi Pete,

Yes, I know, RPG would be the way to do this.  Unfortunately, I'm not an
RPG person and our RPG people are on other projects.  Since this is "web
data", I'm relegated to finding ways of getting the data out of the
iSeries.

While I realize that given my extract application is in Java I will be
confined to JDBC, my thought was if I could pass in a "Java object" and
have something deserialize it, stuff the deserialized data into the
tables, it would probably be faster than the App looping through all of
the parts, getting each individual "table field" data and doing an
"insert" into the database.

This may not be possible, I don't know.  As I've mentioned, I'm not an
RPG/CL/iSeries programmer.  Just a Java/.Net guy trying to think outside
the box.

Kelly 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Thursday, April 27, 2006 3:41 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Passing Java Object to iSeries

Not seeing your code, it is difficult to comment, but your primary DB
connection method in Java will be JDBC, whether you are on the iSeries
or not.  So I doubt there would be a change in connections.

Given the capabilities of RPG, you could eliminate the Java.  RPG is
pretty good at mangling, massaging, twisting and bending data on its
own.

Pete Helgren

Kelly Jones wrote:

>So I was thinking...
> 
>We have this Java app that runs on a WinTel box but gets it's data from

>the iSeries.  Once all of the data has been mangled, massaged, twisted 
>and bent to fit into the format we need, it is then piped back into a 
>set of tables on the iSeries.  One of the problems is that during the 
>process of putting the data back on the iSeries, the application opens 
>around 4000 JDBC connections.  While this method works, it is somewhat 
>slow.
> 
>What I would like to do is pass the objects that have been created by 
>the Java app back to the iSeries and let "something" deserialize them 
>on the iSeries side and stuff the data into the tables.  This would 
>eliminate all of the JDBC connections that are currently part of the 
>app.  I could open one connection, loop over my stuff, have "something"
>on the other side deserialize each object and finally close the 
>connection.
> 
>I'm not familiar with what can be done on the "other side".  Could RPG,

>CL, xxx be the "something"?
> 
>Thanks,
>Kelly
> 
> 
>Kelly Jones
>Sr. Web Developer
>Chef's Catalog
>ph: (719) 272-2600
>fax:  (719) 272.2601
>email: kjones@xxxxxxxxxxxxxxxx
>web: www.chefscatalog.com <http://www.chefscatalog.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.