1 Reply Latest reply on Nov 26, 2002 10:56 AM by Rick Cotton

    Problems with CMR

    Pasha Newbie

      Hello!

      I'm having problems trying to create a CMR example with a 1-to-Many relationship.
      There are two entity beans with corresponding tables in DB: ORGS (id, name, ...) and PERSONS (id, firstname, lastname, ..., org_id).

      EAR deploys without any errors but when I try to get a collection of Persons the following error occurs:

      javax.ejb.TransactionRolledbackLocalException:
      Embedded Exception
      Table not found: PERSONS in statement [SELECT ID FROM PERSONS WHERE (ORG_ID=2)];
      nested exception is:
      javax.ejb.EJBException: Load relation failed

      Any help, info, links would be greatly appreciated.
      Thanks, Pasha.