Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ROLLBACK updates to multiple DB tables when error

Jon CoatAug 6 2018 — edited Aug 23 2018

I have a real-time job reading data from a JMS queue. Each message processed results in rows being written to several Oracle DB tables. The problem I've got is that if an update/insert fails on one table (killing the job) any updates/inserts already made to other tables (for the same input JMS message) are not backed out. How can I "group" these multiple table updates into a single logical unit of work? Is there a setting. Is it possible?

This relates to EDQ v9.0.10(1433) (we do have EDQ v12.1.3 but this job isn't run on that instance yet)

Thanks in advance

Jon

This post has been answered by Mike-Matthews-Oracle on Aug 23 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2018

Added on Aug 6 2018

#data-quality, #master-data-management-mdm

6 comments

459 views