Hi,

I want to specify an "index" on the foreign key column EVENT_ID of table SERVER. I couldn't find a solution to accomplish that as the DTD does not allow be to specify an index attribute on the <key> element.

I also tried to add an additional property to the composite-element which also maps to the column EVENT_ID as hibernate allows me to specify the index attribute for the element <property>. But this fails with a mapping exception.

Is there a way to specify an index on the foreign key column of a SET if this set consists of an composite-element?

<set name="server" table="SERVER" lazy="false">
<key column="EVENT_ID" not-null="true"/>
<composite-element class="xxx.Info">
<property name="dnsName" column="DNS_NAME" length="255"/>
<property name="ipAddress" column="IP_ADDRESS"/>
</composite-element>
</set>

Thanks for your help.

Regards,

Christian Schaefer

You can place a column-node inside your key-node:

Hey,

thanks a lot! That solved my "index" problems.

Thanks especially for the quick reply!

Regards,

Christian Schaefer