JMS/JDBC Transaction clarification

 

Hi All,

 

In my project, for one of the process, i'm getiing repetative elements  and i'm iterating for each of the that element. Now inside that iterating group, i'm using JDBC and JMS activities, and per requirement, if any of JDBC or JMS activity fails, we need to revert back the whole transaction. What would be the best way to achieve it?

If i put "transaction for JDBC"  on top of "iterating group", then in case JMS activity faliure, the transaction won't rolled back.

 

Thanks,

Soumitra

(3) Answers

Login