Calling java from RPG - how to increase performance

Hi Aaron, Paul, Joe Sam,

I'm quite wiling to write an all-java app. Unfortunately, I'm the only guy
in our shop that's touching it so we've got "support" issues. The gusy are
happy as long as the NEP is wrapped in RPG. (go figure!) So I am quite
willing to rewrite as necessary.

Joe Sam,

Regarding my incompatible statements - The main program sits on a data queue
and retrieves an XML path. It is bound to two service programs:

SV1 - this handles the transformation from XML to SQL statements via JNI
calls. The result is placed in a Stream file. This returns the file path of
the result file.

SV2 - this is SQLRPGLE and is passed the file path of the result file. It
then reads the file line-by-line and executes the inserts via dynamic SQL.

I'm perfectly happy to convert to an all-java app (I have the time) but you
may have to guide me a little.

The main thing is that the guys want the NEP to be running in the same
subsystem as all of our other NEPS, it needs to be sitting on a data queue,
and that's practically it.

Any code snippets using data queues and native JDBC would be nice - I can
handle the other "java" stuff.

Also, how do I throw an exception back up to the wrapping Native app?

Your help in this would be extremely welcome.

TIA

Larry Ducie