hiiii
i need someone help please

i have a column that it has to be unique so in the mapping file i wrote :

<property
name="categoryName"
column="CATEGORYNAME_AT"
type="string"
unique="true"
/>

but when i go to mysql to see the tables created and check the CATEGORYNAME column i find the column option "primary key" not checked !!
so i need it to be unique but the option is not taken from the mapping file why???

plz any one has a suggestion ??
i don't know is the problem with the mysql version i am working on ??
just for notice i work under ubuntu environment

Use <id>instead of <property> and generator class is 'uuid.hex',reason is you are using String as primay key,automatically it will be unique,and in database the primay key field should be this property.you will get content name column checked as primary key in table.

so what unique = "true" does when added to a property???

hi,
i will clarify this by an example,
create table(col1 varchar2 primaryKey, col2 varchar2 unique),

here col1 is primary key(notnull,unique),and col2 is also (unique) but not primary key, so for any unique constrained column may not be primary key,
so if u want a property to be checked as primary key option you must give it as <id>,then only primary key option will be checked in database.

I don't agree with Akumar1 because it's not necessary. You are able to define a property that it's unique and that it's not a primary key. h3a i've done this several times and worked fine for me. What's the version of mysql/hibernate/dialect/table engine are you using?

regards,

thx AKumar1

ataveras :
we r using MySQL5InnoDBDialect

so no solution for this