Hi, I have a problem using OQLQuery. I can successfully perstist my objects and query them, but the following does not work properly: SELECT p from myapp.bizobjects.valueobjects.CustomerVO p WHERE p.PersonVO.firstname="John" AND p.PersonVO.name="Smith"
Castor generates the following query: SELECT CUSTOMER.CUSTOMERID,CUSTOMER.CUSTOMERNUMBER,CUSTOMER.COMPANY,CUSTOMER.PASSWORD,CUSTOMER.PHONE,CUSTOMER.MOBILEPHONE,CUSTOMER.FAX,CUSTOMER.EMAIL,CUSTOMER.ADDITIONALTEXT,CUSTOMER.LANGUAGEID,CUSTOMER.PERSON_PERSONID FROM CUSTOMER,PERSON WHERE CUSTOMER.PERSON_PERSONID=PERSON_0.PERSONID AND PERSON_0.FIRSTNAME = 'John' AND PERSON_0.NAME = 'Smith' I think instead of PERSON_O there should be PERSON, I don't know where this _O comes from. Anyone has any tips? Unfortunately the castor JDO example does not contain a scenario like this. Thanks, Balazs ________________________________________________ http://mailbox.hu - Már SMS értesítéssel is! ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
