23.4.2. Composite key example

  1. <class name="Customer">
  3.     <id name="customerId"
  4.         length="10">
  5.         <generator class="assigned"/>
  6.     </id>
  8.     <property name="name" not-null="true" length="100"/>
  9.     <property name="address" not-null="true" length="200"/>
  11.     <list name="orders"
  12.             inverse="true"
  13.             cascade="save-update">
  14.         <key column="customerId"/>
  15.         <index column="orderNumber"/>
  16.         <one-to-many class="Order"/>
  17.     </list>
  19. </class>
  21. <class name="Order" table="CustomerOrder" lazy="true">
  22.     <synchronize table="LineItem"/>
  23.     <synchronize table="Product"/>
  25.     <composite-id name="id" 
  26.             class="Order$Id">
  27.         <key-property name="customerId" length="10"/>
  28.         <key-property name="orderNumber"/>
  29.     </composite-id>
  31.     <property name="orderDate" 
  32.             type="calendar_date"
  33.             not-null="true"/>
  35.     <property name="total">
  36.         <formula>
  37.             ( select sum(li.quantity*p.price) 
  38.             from LineItem li, Product p 
  39.             where li.productId = p.productId 
  40.                 and li.customerId = customerId 
  41.                 and li.orderNumber = orderNumber )
  42.         </formula>
  43.     </property>
  45.     <many-to-one name="customer"
  46.             column="customerId"
  47.             insert="false"
  48.             update="false" 
  49.             not-null="true"/>
  51.     <bag name="lineItems"
  52.             fetch="join" 
  53.             inverse="true"
  54.             cascade="save-update">
  55.         <key>
  56.             <column name="customerId"/>
  57.             <column name="orderNumber"/>
  58.         </key>
  59.         <one-to-many class="LineItem"/>
  60.     </bag>
  62. </class>
  64. <class name="LineItem">
  66.     <composite-id name="id" 
  67.             class="LineItem$Id">
  68.         <key-property name="customerId" length="10"/>
  69.         <key-property name="orderNumber"/>
  70.         <key-property name="productId" length="10"/>
  71.     </composite-id>
  73.     <property name="quantity"/>
  75.     <many-to-one name="order"
  76.             insert="false"
  77.             update="false" 
  78.             not-null="true">
  79.         <column name="customerId"/>
  80.         <column name="orderNumber"/>
  81.     </many-to-one>
  83.     <many-to-one name="product"
  84.             insert="false"
  85.             update="false" 
  86.             not-null="true"
  87.             column="productId"/>
  89. </class>
  91. <class name="Product">
  92.     <synchronize table="LineItem"/>
  94.     <id name="productId"
  95.         length="10">
  96.         <generator class="assigned"/>
  97.     </id>
  99.     <property name="description" 
  100.         not-null="true" 
  101.         length="200"/>
  102.     <property name="price" length="3"/>
  103.     <property name="numberAvailable"/>
  105.     <property name="numberOrdered">
  106.         <formula>
  107.             ( select sum(li.quantity) 
  108.             from LineItem li 
  109.             where li.productId = productId )
  110.         </formula>
  111.     </property>
  113. </class>