Hi,

I am trying to create unique index out of two columns, as show in the mapping xml file. the unique = "true" does not make the index unique, instead, it makes each column a unique key.

My question is:
How can I make unique index, using SchemaExport, in Hibernate .hbm.xml mapping file?

Thank you!

Fan

Hibernate version:
3.0
Mapping documents:
<hibernate-mapping>
<class entity-name="EQ_REFERENCE">
...
...
...
<property name="EXTERNALIDENTIFIER" type="string" length="25">
<column name="EXTERNALIDENTIFIER" not-null="true" unique="true" index="INDEX_EXTERNALIDENTIFIERDELET"/>
</property>
<property name="DeletedStamp" type="timestamp">
<column name="DeletedStamp" unique="true" index="INDEX_EXTERNALIDENTIFIERDELET"/>
</property>
...
...
...
</class>
Name and version of the database you are using:
MySql 4.1, mysql-connector-java-3.1.8-bin.jar
The generated SQL (show_sql=true):
...
...
...
UNIQUE KEY `EXTERNALIDENTIFIER` (`EXTERNALIDENTIFIER`),
UNIQUE KEY `DeletedStamp` (`DeletedStamp`),
KEY `INDEX_EXTERNALIDENTIFIERDELETEDSTAMP` (`EXTERNALIDENTIFIER`,`DeletedStamp`)

check out the <properties> tag in the docs.

yes, or:

unique-key="name"

or, perhaps the best way in very recent versions of HB3 is

<natural-id>