Index creation on MySQL fails

Froestel · **Posted:** Fri Feb 05, 2010 11:14 am

Hi there,

MySQL 5.0.x
Hibernate Core 3.3.2.GA
Hibernate Annotations 3.4.0.GA

I was trying to put an index on a field annotated with

Code:

@Basic
@Column(nullable = false, updatable = false, table = "actor")
@Index(name = "IDX_Actor_name")
private String name;

But the index is not created in the database.

I seem to only get this index created if I make the field UNIQUE.

Is this a bug? MySQL does not enforce index fields to be unique.

CU
Froestel