MQSeries.net :: View topic - Rollbacking DB transactions when the input node is HTTP i/p

Haritha_Flora · Posted: Mon Jan 11, 2021 4:01 pm Post subject:

Hi All,

Hope you are doing well!

We have a requirement that we have to insert data in the three tables at a time (All or none) and commit should happen if three inserts are successful.

Message Flow

Http Input--(out)-->Compute1-->Route to label label--->Subflow--> Http Reply

Http Input--(Failure and Catch)-->Exception handler

subflow

input-->Comput2-->output

Compute 2 transaction mode property set to "Automatic" (default)
DB insert query logics are written at Compute 2

As far as I know commit and rollback should be handled by the integration node as these are broker coordinated transactions . Commit should happen if the transaction is completed successfully. (Please correct me if am incorrect)

But I have observed that DB transactions are committed even though exception raised in the IIB application (Transaction is not completed)

The DB transactions are roll-backing in case of exception if the failure and catch terminals of HTTP input are not connected.

Here my requirement is DB tran Rollback should happen incase of exception even if Failure and catch Terminals of HTTP input are connected.

Please provide your suggestions to achieve this.

Thanks in advance

Thanks
Haritha_Flora[/i]
_________________
Thanks!