Hi, Simply use
SELECT o FROM myapp.Product o WHERE product.group=3 Sandy. -----Original Message----- From: Tetley, Paul [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: [castor-dev] JDO: OQL Question... In the Castor 0.9.5 examples (the JDO Example) I've the OQL Query Analyzer GUI tool and tried to run the query: SELECT o FROM myapp.Product o WHERE product.group.id=3 I get an exception: org.exolab.castor.jdo.QueryException: An unknown field was requested: product.group.id (myapp.Product AS prod) at org.exolab.castor.jdo.oql.ParseTreeWalker.checkProjection(ParseTreeWalke r.java:485) at org.exolab.castor.jdo.oql.ParseTreeWalker.checkWhereClause(ParseTreeWalk er.java:566) at org.exolab.castor.jdo.oql.ParseTreeWalker.checkWhereClause(ParseTreeWalk er.java:590) at org.exolab.castor.jdo.oql.ParseTreeWalker.checkWhereClause(ParseTreeWalk er.java:590) at org.exolab.castor.jdo.oql.ParseTreeWalker.checkErrors(ParseTreeWalker.ja va:236) at org.exolab.castor.jdo.oql.ParseTreeWalker.<init>(ParseTreeWalker.java:13 7) at org.exolab.castor.jdo.engine.OQLQueryImpl.create(OQLQueryImpl.java:275) ... Am I asking the wrong question (in which case how should the query be formulated)? Or is there a problem with my database (HypersonicSQL)? Or is it a bug? :-) TIA Paul Tetley AeM Group Perth, Western Australia ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev **************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *************************************************************************** ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
