We wanted to achieve distributed XA transactions functionality(two-phase commit) within IS. But when I gone through the document, found that webMethods XA’s functionality works only when two DB’s are involved. Is that correct?
In a single transaction, our service will subscribe to the broker and do the transformation and place the document/file in the File System and update a row in the DB and send the acknowledgement to the broker, so that guaranteed document will be deleted and commits it.
In this scenario, if something goes wrong either at File System or DB or Broker, all the activities needs to be rolled back.
Will XA functionality will take care of rolling back the file placed in File system if anything goes wrong with that transaction? Or we need to write a logic separately to delete the uploaded file?
Your valuables inputs will help us a lot.