It is possible to create an EJB relation across 2 MySql databases? I am using JBoss 3.2.1. For example: Database C contains Table Company Table Client Table Company-Client Each Company has at least one Client.
Database D contains Table Data Table Data-C.Company Each piece of Data has at least one Company.
Is it possible to create the D.Data to C.Company relation in an EJB? If so, how? I know how to create multiple datasources by adding to the mysql-ds.xml file, but can I get the 2 datasources to "talk" to each other?