Mule to return multiple rows from a JDBC query as a single transaction

Mule to return multiple rows from a JDBC query as a single transaction 

Option -1

Option -2
Setting transactionPerMessage to 'false' on the connector should work if you ALSO set transactionPerMessage property to 'true' on the endpoint and add a transaction like so