I have a data model which I have to conform to. This data model defines some properties of an object as rows (using a type column), whereas I want to define these as separate variables in my object model.

Basically, Id like to do the following, however the where attribute is not usable:

<class name"parentClass">
<join table="CHILD" where="type ='TYPE_A'" optional="true">
<key column="PARENT_ID"/>
<component name="attA" class="ChildClass">
<property name="initial"/>
<property name="first"/>
<property name="last"/>
</component>
</join>
<join table="CHILD" where="type ='TYPE_B" optional="true">
<key column="PARENT_ID"/>
<component name="attB" class="ChildClass">
<property name="initial"/>
<property name="first"/>
<property name="last"/>
</component>
</join>
</class>

The where attribute is not available on join. Is there any other way to implement this?


thanks in advance