[Hibernate 3] Index not created by SchemaUpdate

最新推荐文章于 2018-05-11 11:02:12 发布

最新推荐文章于 2018-05-11 11:02:12 发布 · 139 阅读

文章标签：

#Hibernate #OpenSource #UP #XML

Hibernate 专栏收录该内容

3 篇文章

订阅专栏

当使用Hibernate并设置hibernate.hbm2ddl.auto为'update'时，普通的索引如idx_id_a不会被自动创建。若索引关联的是主键或唯一键，则会自动创建。此行为被视为Hibernate的一个已知问题。

A normal index like the one below won't get created automatically if hibernate.hbm2ddl.auto is set to [b]update[/b].


<property 
    name="idA" 
    index="idx_id_a" 
    not-null="true" 
    type="long" 
    column="..."/>

If the property is a primary key or it's unique, the index will be created, however. It's a hibernate bug reported here: [url]http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012[/url].

A simple solution will be creating the index locally and migrating the creation script to the live system. If you opt for hibernate.hbm2ddl.auto = [b]create[/b], all data need to be backed up as this option clears the database before reconstructing the whole schema.