How to specify relationship in mapping file

[Gaurav Chikara]

Hi All
I have the following mapping file in hibernate

hibernate-mapping default-cascade="all" default-lazy="false"> 
 
  <class name="com.company.qg.bo.QuoteHeaderBO" table="QG_QUOTE_HEADER">
    <id name="quoteId" type="long" column="QUOTE_ID" >
      <generator class="sequence">
              <param name="sequence">QG_QUOTE_HEADER_S</param>
      </generator>
    </id>
    <many-to-one name="quoteId" cascade="none" column="QUOTE_ID" cascade = "none"/>
    <property name="userId" column="USER_ID"/>
    <property name="customerName" column="CUSTOMER_NAME"/>    
  </class>

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 ]

[Ghulam Rashid]

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.

[Arun Kumarr]

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

:roll:

[Gaurav Chikara]

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 ]

[Ghulam Rashid]

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.

 
<hibernate-mapping default-cascade="all" default-lazy="false"> 
 
<class name="com.company.qg.bo.QuoteHeaderBO" table="QG_QUOTE_HEADER">
<id name="quoteId" type="long" column="QUOTE_ID" >
<generator class="sequence">
<param name="sequence">QG_QUOTE_HEADER_S</param>
</generator>
</id>

<!-- 
<many-to-one name="quoteId" cascade="none" column="QUOTE_ID" cascade = "none"/> 
-->
<set name="quoteIdSet" cascade="none"> 
<key column="QUOTE_ID"/>
   <one-to-many class="QuoteDetailBO"  /> 
</set>

<property name="userId" column="USER_ID"/>
<property name="customerName" column="CUSTOMER_NAME"/> 
</class>
</hibernate-mapping>