Hi everybody,

I'm using Hibernate 2.2 with XDoclet to generate mapping files and sql-code for my Oracle 9 database. Now I want to define a unique key via XDoclet. To do so for a single property you have just to add:

That works, no problems.

But how could I make two or more properties unique? For example I want the combination of "name" and "birthday" to appear only once in a table.
I tried with:
I thought that every column with the same unique-key would be included in a group of unique columns. But I get an Exception:


Any suggestions what I did wrong? What should I change?

smo

Looking at http://xdoclet.net/xdoclet/tags/hibernate-tags.html#@hibernate_column__0____
Shows that the column tag supports unique="true" so you should be able to set it that way if its a subset of the property. If you want separate properties to have a unique constraint across them, it will have to be defined in a separate DDL script.

Thanks for your answer. I think I will skip defining a seperate DDL script for now, but maybe will try this later..

smo

has worked for me. Try getting rid of unique keyword within double quotes.

Sorry, I don't know what I did wrong last time but it's working now, even with the "unique" keyword.

smo