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:
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.
2nd try at responding: I am a newbie trying to do the same thing. I can establish the relationship - I think - but not a EJB-QL tag that uses the relationship.
contact me directly at firstname.lastname@example.org