Calling RPG as part of a java/jdbc transaction
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   sepp_muegeli
Posted On:   Monday, May 7, 2001 05:04 AM

The RPG programm should act as a part of a transaction. That means, do some update via JDBC, call RPG, do some more updates via JDBC. Then do a commit or rollback that should affect all the updates from JDBC *AND* from the RPG program.Is there a possible way to do this?

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

Posted By:   sepp_muegeli  
Posted On:   Monday, May 21, 2001 11:42 PM

I found a solution to the problem, perhaps this might be of interest for some of you, too.



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-control of the calling java-program.

About | Sitemap | Contact