[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Multiple datasources to one database. Effectiveness?

What if one application (EAR) uses multiple datasources for different appliciation parts (modules, EJB jars) but only one physical database (Oracle) let's say from legacy reasons. Different entities can use different datasources in single transaction. Everything works but how much is this solution effective? Are there any hidden costs for such configuration? How inteligent is EntityManager to handle such case? Aren't unnecessary 2PCs (two phase commit) triggered? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106419#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...