Hi all,

I try to figure out the following:

A class A (attributes a_id, b) has a 1:1 association (unidirectional) to class B (attribute b_id). The association is persisted in a join table AB (attributes a_id, b_id, discriminator). The 1:1 association can be found with the aid of the discriminator (lets say discriminator must be 'X'). The incomplete solution (for the mapping file A) might be:

<join table="AB"
optional="true">
<key column="a_id"
unique="true"/>
<many-to-one name="b"
column="b_id"
not-null="true"
unique="true"
class="B"/>
</join>

How can I add the additional condition "discriminator='X'" to the mapping ?

Thanks for any help,
Mike

Why don't you use class A (attributes a_id, b) and class B (attribute b_id,attributes a_id) with a_id like an foreign key to A and then use a one-to-one association ?

Hi Crista,

there are several reasons for this design (e.g. the join table contains in real world three types of associations). Isn't there any way to accomplish this mapping ?

Thanks,
Mike