Hibernate version: 3.0


How can I define a composite unique key in my hibernate mapping.
I have for example the following table:

Product
- id <id>
- productgroup_id <fk>
- code
- description
- price

Now I want to define two composite unique keys:
1: productgroup_id + code
2: productgroup_id + description

In words: a product code should be unique within the productgroup.
The same counts for the description.

Regards,
Marcel

<hibernate-mapping>
<class table="product" name="xxxx.Product">
<id name="id" type="long" column="id">
<generator class="increment"/>
</id>

<properties name="fsUniqueValue" unique="true">
<property name="idDocument" column="idDocument" index="FeatStatDocExtSectFeat" not-null="false" type="long" insert="false" update="false"/>
<property name="idSection" column="idSection" index="FeatStatDocExtSectFeat" not-null="false" type="integer" insert="false" update="false"/>
<property name="idExtraction" column="idExtraction" index="FeatStatDocExtSectFeat" not-null="false" type="integer" insert="false" update="false"/>
<many-to-one class="com.temis.tm.model.Feature" index="FeatStatDocExtSectFeat" name="feature" not-null="true">
<column name="idFeature"/>
</many-to-one>
<property name="leaf" column="leaf" type="boolean"/>
</properties>
<property name="frequency" column="frequency" not-null="true" type="integer"/>
<property name="idFatherFeature" column="idFatherFeature" not-null="true" type="long"/>

<many-to-one class="com.temis.tm.model.Feature" name="feature" not-null="true" column="idFeature" insert="false" update="false"/>
</class>
</hibernate-mapping>

Sorry mismatch with my keyboard

<hibernate-mapping>
<class table="product" name="xxxx.Product">
<id name="id" type="long" column="id">
<generator class="increment"/>
</id>

<properties name="fsUniqueValue" unique="true">
<property name="productgroup_id" column="productgroup_id" not-null="xxx" type="xxx" insert="false" update="false"/>
<property name="code" column="code" type="xxx" insert="false" update="false"/>
</properties>

<properties name="fsUniqueValue2" unique="true">
<property name="productgroup_id" column="productgroup_id" not-null="xxx" type="xxx" insert="false" update="false"/>
<property name="description" column="description" not-null="xxx" type="xxx" insert="false" update="false"/>
</properties>

<property name="description" .../>
<property name="code" .../>

Sorry again for my first message

Xavier