added new transaction API on ConnectionInterface and its implementors. refs #368.
added initial tests.