Andre, have a look at the following Castor JDO F.A.Q. item:
http://castor.exolab.org/jdo-faq.html#Does-Castor-support-the-SQL-'IN'-expression? Werner On Fri, 14 May 2004 12:52:06 +0200, Andre Teubner wrote: > >Hello list, > >i' ve another question to OQL : > >I have a object , called MeasureToPlan, that contains a attribute type >_arraylist_ >wich contains element type= Prophylaxis. My problem is is build an OQL- >query >like this : > >SELECT mea FROM com.morixs.mcare.bo.holder.planning.MeasureToPlan mea >WHERE mea.listedInProphylaxises = $1 > >Ok, the query above does not work...but how can i get it to..? With OQL >of course... > >Another try brought me a NullPointerException...! > >CALL SQL SELECT * FROM PLAB_MEASURE TOPLAN > WHERE TOPLAN.ID IN > ( > SELECT PROP.MEASURE_ID FROM PLAB_MEASURES_TO_PROPHYLAXIS PROP > WHERE PROP.ID=1006 > ) > AS com.morixs.mcare.bo.holder.planning.MeasureToPlan > >java.lang.NullPointerException > at org.exolab.castor.jdo.engine.SQLEngine.createCall(SQLEngine.java:416) > at >org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:499) > at >org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:459) > at >org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:451) > at >com.morixs.mcare.ds.castor.planning.ProphylaxisDS.getAllMeasuresForProphylaxis(ProphylaxisDS.java:98) > >The SQL- part works fine in SQL- monitor. I' ve no suggestion how to >solve this problem... > >Thank in advance > >Andre Teubner > >PS: After 1 1/2 years works with castor, it looks like pandoras >box...every day a new 'suprise' > > > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
