Bonjour ,

J'ai l'erreur suivante :
org.hibernate.MappingException: Repeated column in mapping for entity: model.Child_TC column: ac_id (should be mapped with insert="false" update="false")
at org.hibernate.mapping.PersistentClass.checkColumnDuplication(PersistentClass.java:504)
at org.hibernate.mapping.PersistentClass.checkColumnDuplication(PersistentClass.java:542)


Je pense que c'est du faite que je veux mettre en PrimaryKey/ForignKey dans la table Child_Tc deux attribut childtc et fathertc qui sont tout 2 des FK de ac_id identifiant de la table AC, donc il y a une repetition de colonne mais c'est normal je veux faire en sql :

CREATE TABLE CHILDTC(child_tc_id integer NOT NULL,
father_tc_id integer NOT NULL,
channel_number integer,
constraint constcfchild foreign key(child_tc_id) references AC(ac_id),
constraint constcfkfather foreign key(father_tc_id) references AC(ac_id),
PRIMARY KEY (father_tc_id, child_tc_id)
);

le code de child_tc.hbm.xml est :

<hibernate-mapping>

<class name="model.Child_TC" table="CHILD_TC">

<composite-id name="compositeID" class=" model.Child_TC">
<key-many-to-one name="child_tc_id" class="model.AC" column="ac_id"
/>
<key-many-to-one name="father_tc_id" class="model.AC" column="ac_id"
/>
</composite-id>

<property name="channel_number" type="int">
<column name="channel_number" sql-type="int" not-null="true"/>
</property>

</class>

</hibernate-mapping>



Hibernate version: 3.0

Mapping documents: 3.0

Name and version of the database you are using: oracle 8.1

Tu mélanges des notions