Recently I was going through the documentation of Jdbc adapter(6.5), I have found that SAG doesn’t recommend putting ‘pub.art.transaction:startTransaction’ in SEQUENCE step. I am unable to find out the reason behind it.
The reason for it should be outside of the sequence step is the transactionName can be always there in the pipeline even in the case of catch block errors scenario and the rollback situation does get work as expected making the transactionName available if any hard errors.
Calling StartTransaction simply means u r using LocalTransaction as a Transaction Type and for this we have to put in a transaction Boundary.
Say inside main U cant call because control will come out after getting first success, yes you can call inside try block but this is not our best practice.
so best to use the first step inside a flow service.