Re: RPG and Java question

...yes, there are lots of possibilities.
- use a connection pool
- use only one connection
- use TrasnsferData, its Open Source and available at my (german) Freeware site bender-dv.de
- install ArdGate and use a simple QMQRY
ArdGate is Open Source too and is available at Sourceforge, (google for AppServer4RPG)

Dieter Bender

--------------------------------------------------
From: "Mike Cunningham" <mike.cunningham@xxxxxxx>
Sent: Wednesday, December 08, 2010 4:09 AM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: RPG and Java question

I had one of our java developers write a utility that can use the JDBC driver to connect to an MS SQL database and then replicate a table to DB2. The java accepts there options. CREATE, CLEAR and LOAD. Create will check to see of the DB2 table already exists and if not will get the specs of the table from MS SQL and create a DB2 version using SQL. CLEAR will clear the DB2 table and LOAD will copy the MS SQL table to DB2. The app works fine but as it is running it is generating lots of QZDASOINIT job logs. Is there anything I can do to make the entire job use the same instance of QZDASOINIT for all SQL requests?
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.