0 Replies Latest reply on Nov 21, 2003 3:56 PM by hale2jo

    EJB relation across databases

      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