[castor-dev] [OQL] Query for attribute in collection="arraylist"

[Andre Teubner]

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