I'm using Hibernate 2.0.2.

Here is my mapping file:

<class name="Sample" table="sample">
<id name="id" type="GuidType">
<generator class="GuidGenerator"/>
</id>
<property name="name" type="string">
<column name="name" unique-key="u_idx_sample_name"
not-null="true"/>
</property>
<property name="status" not-null="true" type="StatusType"/>
</class>

Instead of naming the index using the value of unique-key it gives it a name of "SYS_IDX_4".

FYI, I want to name the index so I can inspect the exception for it and throw a custom UniqueViolationException. If I can't name the exception is there a better way to do this?

TIA

Don't generate the schema through Hibernate?

I craft the database schemas by hand, not only for this reason but many others (i.e., oracle tablespaces, storage options)..

Hibernate creates the unique constraint in the create table, not an alter table - so the database assigns a name.