Hi all,

I have three tables:
Table ACCOUNT, pk = acco_id
Table SUBSCRIBER, pk = subb_id

and

Table ACCO_SUBCRI, pk = component id (acco_id, subb_id)
This table contains not only the relationship, but also other fields like
e.g. actif, date activation,

show generated sql

Ok sorry, I found this one work's :

<hibernate-mapping>
<class name="com.my.AccoSubbBEAN" table="ACCO_SUBCRI">

<composite-id>
<key-property name="acco_id" column="acco_id" type="integer"/>
<key-property name="subb_id" column="subb_id" type="integer"/>
</composite-id>

<property name="accsubb_actif" column="accsubb_actif"/>

<many-to-one name="account" class="com.my.AccountBEAN" column="acco_id" insert="false" update="false" />
<many-to-one name="subscriber" class="com.my.SubscriberBEAN" column="subb_id" insert="false" update="false" />

</class>
</hibernate-mapping>