How to specify relationship in mapping file

Hi All
I have the following mapping file in hibernate

where I am trying to specify relationship of quoteId with another quote_detail table but hibernate is throwing an exception saying that duplicate property name specified

Is there any way we can specify these kind of relationships in hibernate
Thanks in advance
:roll:
[ August 10, 2006: Message edited by: Gaurav Chikara ]

Could be please post your other mapping. I remembered I had this problem once, I may look into. Dont use <code> because its difficult to read.

Originally posted by Ghulam Rashid:
Dont use <code> because its difficult to read.

:roll:

This was my other file

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

<hibernate-mapping default-cascade="all" default-lazy="false"> 
 
  <class name="com.company.qg.bo.QuoteDetailBO" table="QG_QUOTE_DETAIL">
    <id name="quoteDetailId" type="long" column="QUOTE_DETAIL_ID" >
      <generator class="sequence">
        <param name="sequence">QG_QUOTE_DETAIL_S</param>
      </generator>    
    </id>
    <property name="lineId" column="LINE_ID"/>
    <property name="productFamily" column="PRODUCT_FAMILY"/>
    <property name="sku" column="SKU"/>
    <property name="picProductType" column="PIC_PRODUCT_TYPE"/>
    <property name="description" column="DESCRIPTION"/>
    <property name="quantity" column="QUANTITY"/>
    <property name="msrp" column="MSRP"/>
    <property name="language" column="LANGUAGE"/>
    <property name="license" column="LICENSE"/>
    <property name="maintenance" column="MAINTENANCE"/>
    
    <property name="band" column="BAND"/>
    <property name="creationDate" column="CREATION_DATE"/>
    <property name="createdBy" column="CREATED_BY"/>
    <property name="lastUpdateDate" column="LAST_UPDATE_DATE"/>
    <property name="lastUpdatedBy" column="LAST_UPDATED_BY"/>
    <many-to-one name="quoteId" column="QUOTE_ID" class="com.symantec.qg.bo.QuoteHeaderBO" cascade="delete"/>
  </class>
  
  <query name = "getTotalGBPValue">
   SELECT sum(msrp*quantity) from com.symantec.qg.bo.QuoteDetailBO where quoteId=?
   group by quoteId
  </query>
  
</hibernate-mapping>

I am putting code because moderator asked me to do so as it retains the formatting
[ August 11, 2006: Message edited by: Gaurav Chikara ]

This is what I understood from your mapping.

QuoteHeaderBO(One)---------------(Many)QuoteDetailBO

If this is what you are trying to map then QuoteHeaderBO.hbm.xml should have collction mapping for holding multiple QuoteDetailBO that we can define using bag,set ... because you have define many-to-one on both xml but you have not define one-to-many (inside bag/set) in QuoteHeaderBO. That could be the reason hibernate might be confusing.

Your mapping for QuoteHeaderBO should look like this.