MODE-1822 Added tests that use Atomikos transaction manager

Other fixes for MODE-1819 actually fixed the problem, while this
change only adds test cases and test dependencies on Atomikos to
verify the expected behavior now works. Also added similar tests
that use the JBoss Transactions library.