Hi , I am working on a requirement in Mule 4 where i have to calls 3 Stored Procedure connectors in a sequence say SP1,SP2 and SP3. These Stored procedures are inserting data into different tables . The main requirement is that when any of the SP fails , inserts done by previous SP's should rollback.
Using Sybase database with JTDS driver , can you please suggest how to deal with this .
2 件の回答
A better solution would be to write a wrapper procedure, that invokes the 3 procedures in sequence and surround them with a BEGIN Transaction and have the commit in the outer loop. Inner procedures commits should not be applied to the DB without the outer commit. Refer
