Re: Calling RPG as part of a java/jdbc transaction

Hi

I posted this question two weeks ago (original posting below). I now found
a possible solution:

1. Use commitment-control from java as usual (auto-commit off, transaction
isolation level != none)
2. Use the keyword "COMMIT" in the file specification section in the
RPG-program
3. Create the ILE-RPG program with activation-group *CALLER

The stored procedure should now run under the commitment-controll of the
calling java-program.

Perhaps this might be of interest for some of you, too.

Sepp


Hi all,

I have to call a RPG-program from Java on the AS/400. There are many ways
to do this, I use stored procedures for now. The problem is, that the
RPG-program should act as a part of a transaction. That means, do some
update via jdbc, call the RPG, do some more updates via jdbc. Then do a
commit or rollback that should commit/rollback all the updates from jdbc
AND from the RPG-program.
Is there a possible way to do this?

Thanks for any answers.


Sepp Muegeli
DV Bern AG
____________________________________________________________
mailto:sepp.muegeli@dvbern.ch  /  http://www.dvbern.ch
X.400 Adresse:  G=sepp; S=muegeli; P=ibmmail; A=ibmx400; C=ch
Briefpost:  Sulgenauweg 40 ,  CH-3007 Bern
Tel: / Int. / Fax:  ++41+31 378 24 54  /  454  /  ++41+31 378 24 74





+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---