I am using explicit LOCAL_TRANSACTION JDBC adapter in flows
to control commit and rollback for a set of transaction.
IF I start a transaction and read records from JDBCAdapter1
and only if certain criteria is met do I insert/update to JBDCAdapter2.
If I don’t insert/update to JDBCAdapter2 and run commit or rollback
on the selection only I get NULL transaction error.
How can I avoid this Null transaction as I need to loop over
multiple customers and when I startTransaction again in the loop I get
Unable to establish connection to connection error
as I have two JDBC adapters that I am using in the explicit transaction
Is there a way to start a transaction and then release it without
database insert/update for the select step?