Hi all,

Can Hibernate generate a unique index based on multiple columns?
I don't want to use composite id, but native generated id(key).

Basically, what I want to achieve, is to ensure unique records in the DB based on a set of columns, w/out composite keys.

TIA,
--steve p.

Has this problem resolved? I also interest it.

thanks everyone in advance.

http://www.hibernate.org/hib_docs/reference/html/toolsetguide.html#toolsetguide-s1-2 - use unique-key I suppose

Hi,

Related to the issue, it seems neither the unique attribute nor the unique-key attribute works in many-to-one mapping:

<many-to-one name="manufacturer" class="data.Manufacturer" column="manufacturer_id" >
<column name="manufacturer_id" unique="true" unique-key="mfmodel" />
</many-to-one>

The unique constraint doesn't appear in the generated ddl at all.

Is there anything wrong in the mapping?

Thanks a lot in advance!