Thanks for the ideas! I intend to have the commit and rollback as part of the transaction template so you don't forget it, that's why two different templates are needed.
I originally intended one template with automatic choice but was convinced otherwise by the kind responders.