RE: Passing Java Object to iSeries

Dan,

Thanks for the tip.  I will see if I can locate the guide.  If you could
provide some examples, that would be fantastic.

As for the connection, I'm actually using a CallableStatement so all of
the "sql" is in stored procedures and functions on the iSeries.

I'm going to change the way I instantiate the connection and see if I
get any performance gains, but I'm not hopeful.  If I can instantiate
the connection in the class as a property, leave it open for the entire
time the calling method is using it and make it available to all of the
methods in the class, that might helpful.

But I've seen how fast native code runs on the iSeries when
retrieving/saving data.  Doing from the "outside" using select/inserts
from JDBC just feels slow to me.

Kelly


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

As far as de-serializing a Java object in RPG, I haven't seen that done.
However, using a Java object in RPG is fairly simple. My starting point
for figuring that out was the "WebSphere Development Studio: ILE RPG
Programmer's Guide" from IBM. It describes how to start the JVM,
instantiate Java objects, call methods, etc. from RPG. It doesn't
address your de-serialization objective, but it could be a good way of
showing your RPG developers how to access Java from within their RPG
programs. I can send you a simple example if you like.

Sorry to keep visiting this and I don't mean to insult your
intelligence, but on your connection issue and the maximum number of
statements error, were you using a prepared statement or were you
dynamically creating your statement every time?

Dan Feather

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