With a 1:m castor mapping like

<class name="worktime_monthly" identity="id"
   key-generator="MAX">
   <map-to table="worktime_monthly"/>
     <field name="id" type="integer">
       <sql name="ID" type="integer" />
     </field>
     <field name="totalhours" type="java.lang.String">
       <sql name="TOTALHOURS" type="char" />
     </field>
<field name="daily_hours" type="worktime_daily" collection="arraylist">
       <sql many-key="PARENT_worktime_monthly"/>
     </field>
   </class>

 <class name="worktime_daily" identity="id"
   key-generator="MAX"
   depends="persistence.worktime_monthly">
   <map-to table="worktime_daily"/>
     <field name="id" type="integer">
       <sql name="ID" type="integer" />
     </field>
     <field name="workday" type="integer">
       <sql name="WORKDAY" type="integer" />
     </field>
     <field name="workhours" type="java.lang.String">
       <sql name="WORKHOURS" type="char" />
     </field>
     <field name="parent_worktime_monthly" type="worktime_monthly">
       <sql name="PARENT_worktime_monthly" />
     </field>
   </class>

it is NOT possible to perform a OQLQuery on worktime_daily, only on worktime_monthly as far as I've tried. So, e.g. If I wanted to select all worktime where workday is 1 would I have to iterate over worktime_monthly or is there a more comfortable way?
"select form worktime_daily where ..." seems not to be possible.

Thanks in advance
Andreas


-------------------------------------------------
If you wish to unsubscribe from this list, please send an empty message to the following address:

[EMAIL PROTECTED]
-------------------------------------------------

Reply via email to