Creating Indexes on DB with Hibernate @Index Annotation

user_54929 0
Viewed 31140

I have annotation-driven hibernate capabilies on my project.

Now I want to create an index over a column. My current column definition is

@NotNull
@Column(name = "hash")
private String hash;

and I add @Index annotation here.

@NotNull
@Column(name = "hash")
@Index(name="hashIndex")
private String hash;

and then DROP TABLE and restart Tomcat server. After the server is instantiated, the table is created but I can't see new index on following query. 

SHOW INDEX FROM tableName

It is expected to construct table with new index. I am using InnoDB with MySQL.

hibernate-annotations database-indexes annotations hibernate java
4 Answers

In Hibernate 3.5.6 using <property name="hibernate.hbm2ddl.auto">update</property> the indexes are created. So a proper answer now would be to upgrade. But I'm leaving this answer for those like me that have come across this question.

user_10068630
Related