major refactoring of transaction model to align with JTA and provide
future mutli-database support.