Hibernate version: 3.2.3

Mapping documents:

<class name="Alarm"
<id name="alarmId" column="alarm_id">
<generator class="assigned"/>
</id>

<property name="alarmDefinitionId">
<column name="alarm_definition_id" />
</property>

<property name="alarmDefinitionVersion">
<column name="version_id" />
</property>

<join table="alarm_definition">
<key column="alarm_definition_id" property-ref="alarmDefinitionId"/>
<key column="alarmDefinitionVersion" property-ref="version_id"/>
<property name="alarmDefinitionName" column="name"/>
</join>
</class>


Name and version of the database you are using: Oracle 9i

I would like to join a table called alarm with another table called alarm_definition to retrieve a single column from the alarm_definition table called name.

My problem is that the primary key of the alarm_definition table is made up of 2 columns. I need to join the alarm table by both alarm_definition_id and version_id. I cannot find a way to do this. I expected to be able to do something like the join below but the join element can have only one key element and key can have only one column element.

<join table="alarm_definition">
<key column="alarm_definition_id" property-ref="alarmDefinitionId"/>
<key column="alarmDefinitionVersion" property-ref="version_id"/>
<property name="alarmDefinitionName" column="name"/>

</join>

Any help would be appreciated.