Currently I’m thinking that doing an application commits transaction on multi-databases with different schema, I’m confused of the pattern that doing such action. i will dependent on the following software’s and tools.
- Hibernate as JPA provider
- Oracle database
- WebSphere application server 6.1 server.