Two times <key-many-to-one/> in <composite-id/>

awt · **Joined:** Thu Dec 11, 2003 9:54 am **Posts:** 25

I got troubles with next mapping file:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
    
<hibernate-mapping>
<!-- 
    Created by Middlegen Hibernate plugin

    http://boss.bekk.no/boss/middlegen/
    http://hibernate.sourceforge.net/
-->

<class 
    name="First" 
    table="FIRST"
>

    <composite-id name="comp_id" class="FirstPK">
        <key-property 
            name="Id" 
            column="ID" 
            type="java.math.BigDecimal"
            length="22"
        />
        <!-- bi-directional many-to-one association to Second -->
        <key-many-to-one
           name="second"
         class="Second"
          column="TYPEE"
        />
        <!-- bi-directional many-to-one association to Third -->
        <key-many-to-one
           name="third"
         class="Third"
          column="TYPEE"
        />
    </composite-id>

    <!-- associations -->

</class>
</hibernate-mapping>

the error is next:

HibernateException: net.sf.hibernate.MappingException: Repeated column in mapping for class First should be mapped with insert="false" update="false": TYPEE

How I can mapped it ?

max · **Posted:** Fri Dec 12, 2003 10:44 am

You are referring to the same column more than once (as stated in the exception) - thus you have to tell Hibernate which property should be the dominant one. There can't be more than one property that tells what the value should be...because how should hibernate know which one to save if the properties somehow returned different results ?

max · **Posted:** Fri Dec 12, 2003 10:45 am

....so, you should just do what the exception says:

Mark the non-dominant properties as insert="false" update="false"

awt · **Joined:** Thu Dec 11, 2003 9:54 am **Posts:** 25

max wrote:

....so, you should just do what the exception says:

Mark the non-dominant properties as insert="false" update="false"

I'v tried, but without success...

max · **Posted:** Fri Dec 12, 2003 7:01 pm

Post an example that fails (with a main method!)

shand1216 · **Posted:** Mon Dec 15, 2003 6:07 pm

I noticed this problem myself when trying to deal with mappings that use the same column more than once. The problem he is having is that the <key-many-to-one> tag does NOT allow insert="false" update="false".

Luckily, my scenario has the duplicated column between a <key-many-to-one> and <many-to-one> tag so I could put the insert="false" update="false" stuff on the <many-to-one>.

Hope this helps clarify the problem, if not the solution.

Sarah