Let me explain the problem.
I am doing a mapping on a relationnal database
I have an object A, which has an attribute object B, and the dependance between those
objects is described by a table of reference. The fields in this table are as follow :
Table REF_A_B
ID_A varchar
ID_B varchar
VALIDITY date
my xml mapping goes like this so far :
<class name="B" identity="id">
<map-to table="TableB"/>
<field name="id" type="string">
<sql name="ID_B" type="varchar"/>
</field>
...
</class>
<class name="A" identity="id">
<map-to table="TableA"/>
<field name="id" type="string">
<sql name="ID_A" type="varchar"/>
</field>
...
<field name="myB" type="B">
<sql many-table="REF_A_B"
many-key="ID_A" name="ID_B"/>
</field>
...
</class>
Do you know if there is a way to get the object B according to a date of validity
(include the field VALIDITY in the description of the many-table...) ?
Thanks
_________________________________
Vincent BOESCH
Architecte du Système d'Information
Cellule ATF DO-A
05 56 46 61 21
06 81 95 15 03
[EMAIL PROTECTED]
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
