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?
Thanks in advance,
Josephine