I have some problem when I use the tag <set ...>

I've done something like this :

<!-- TABLE DEC_COMPOSANTE_BATIMENT -->
<class name="HbDecComposanteBatiment"
table="DEC_COMPOSANTE_BATIMENT">

<id name="id" column="ID_COMPOSANTE_BATIMENT" type="java.lang.Long">
.....


<set name="composantesBatimentAvApr" table="DEC_LIEN_COMPO_BATIMENT_AV_APR"
lazy="true" cascade="none">
<key>
<column name="ID_COMPOSANTE_BATIMENT" not-null="true"/>
</key>
<many-to-many class="HbDecComposanteBatiment">
<column name="ID_COMPOSANTE_BATIMENT" not-null="true"/>
</many-to-many>
</set>

--> I obtain the following error :

"Repeated column in mapping for collection: vdm.administration.referentiel.dao.hbbean.HbDecComposanteBatiment.composantesBatimentAvApr column: ID_COMPOSANTE_BATIMENT"


As you can see I have twice the column ID_COMPOSANTE_BATIMENT in the tag <set> because I made a many-to-many association on the same table (HbDecComposanteBatiment references itsef in a many-to-many association).

How can I avoid this problem ?

Thanks for your help,

Nicolas
[/b]

Hi,
Try this one


The avant id should be distinct from thez apr

Ok thank you, I thought I was obliged to use the id's names specified in my relationnal database in the mapping file.

But it seems I'm not obliged, thus you're right.


Thanks


Nicolas