A little help please?
I have a scenario where we will make multiple stored procedure calls to a database.
I am thinking of doing in this with BPM as if any of the calls fail then I want all previous calls to be rolled back to its original state.
I have looked at the following help link(below) and I think this could be a solution but I dont completely understand it so I was wondering if someone could comfirm if this is the way to go.... or are there any other solutions.... Again my scenario is that I will collect some messages in BPM then make the calls to the database with the JDBC adapter... If any of the messages fail in the database then I want all previous updates from that BPM to be rolled back.