Antwort: RE: Passing Java Object to iSeries

Hi Kelly!

Please can you provide some of your code. I think there is something 
pretty wrong with your JDBC code. I have testest JDBC against native file 
access and JDBC is pretyy similar to native file access. Are you using 
preparedStatements? So please provide your code and i am sure i can give 
you hints to make your code perform well.

Greetings

Ralf M Petter





"Kelly Jones" <kjones@xxxxxxxxxxxxxxxx> 
Gesendet von: java400-l-bounces@xxxxxxxxxxxx
28.04.2006 00:40
Bitte antworten an
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


An
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
Kopie

Thema
RE: Passing Java Object to iSeries






No, I mean be able to call methods within the object.  For instance, an
object might have a method to getPrice(), getItemNumber(),
getWarehouseCollection().  The first two are pretty straight forward,
but my getWarehouseCollection would return another object containing an
array of warehouses which contains a method called getWarehouseNumber().


I basically want to iterate through the top level "object" and call
methods which would return the inner objects, call those methods, get
inner objects, etc. etc.  I ultimately need to "flatten" an object down
into data which can be inserted into tables.

Kelly
 

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

Can you clear something up for me? What exactly do you mean by
de-serialize each object? I assumed you just want to manipulate string
data. I was thinking you could pass the string to an RPG program and the
RPG program could then do the manipulation and populate the tables on
the iSeries. 


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kelly Jones
Sent: Thursday, April 27, 2006 4:00 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Passing Java Object to iSeries

Hmm, so RPG might be an option?  Interesting.  Unfortunately I'm having
a difficult time explaining what Java object are and how they work to
our RPG programmers.  And I'm not an RPG coder, so kind of hitting a
brick wall. 

Suggestions or examples?

Thanks -
Kelly


 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Grizzly Malchow
Sent: Thursday, April 27, 2006 2:25 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Passing Java Object to iSeries

Both RPG and CL could be used. I would imagine you could use C as well.
As far as I know RPG would be best for file (table) I/O. 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kelly Jones
Sent: Thursday, April 27, 2006 2:53 PM
To: java400-l@xxxxxxxxxxxx
Subject: Passing Java Object to iSeries

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.


--
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.