Hi,

I am using the schema export feature quite extensively as I develop my domain and was wondering if it is possible in the mapping files to create a unique constraint/index across multiple properties. For example, suppose I have the following 2 properties in an Order object:



I want to ensure that the order reference number is unique within each customer and would like that constraint created in the DB as well as doing the validation in my domain. Is this possible in the mapping file or do I just have to add those types of constraints in the DB manually?

Cheers,

Jason

Using unique="true" should do it.

Hi Sergey,

I have already tried adding that attribute to the mappings but nothing extra gets generated in the SQL...is this a bug? I couldn't find anything in the doco's about the use of the attribute on the property element either although it does mention it for the assocation elements.

Will the unique attribute look at multiple properties to generate a single unique constraint or will it generate one unique constraint per property?

Cheers,

Jason

Hmm, it should have worked. Which dialect are you using?

You can also try specifying <column unique-key="SomeName" />, then one constraint will be created for all the columns that share the same unique-key value.

Sorry Sergey, it does currently add the unique attribute to each column in the SQL when you specify unique="true" on the property...not sure how I missed this before!

The unique-key attribute on the column element is exactly what I am looking for though...thanks.

Jason