[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1012) index not created by SchemaUpdate

[Andy D. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012?page=comments#action_20754 ] 

Andy DePue commented on HHH-1012:
---------------------------------

Yes, this problem exists in both versions of Hibernate (probably the reason for two JIRA issues).  I'm also seeing it against PostgreSQL (the other issue mentions MySQL).  Hibernate is not creating any indices for us.

> index not created by SchemaUpdate
> ---------------------------------
>
>          Key: HHH-1012
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012
>      Project: Hibernate3
>         Type: Bug
>     Versions: 3.0.5, 3.1 beta 1, 3.1 beta 2
>  Environment: Windows XP, MySQL/PostgreSQL
>     Reporter: Xavier Farret
>     Priority: Minor

>
>
> i'm using an hbm.xml as describe below and the 'hibernate.hbm2ddl.auto' is egal to update. 
> <class table="featurestat" name=".....">
>     <id name="id" type="long" column="idFeatureStat">
>       <generator class="increment"/>
>     </id>
>      <properties name="fsUniqueValue" unique="true">
>            ....
>      </properties>
>       <property name="frequency" .../>
>      <property name="idFatherFeature" index="FeatStatDocExtSectFeat" not-null="true" type="long" column="..."/>
>      ....
> </class>
> Indexes for pk or unique key are well created, but the index explicity named 'FeatStatDocExtSectFeat' is never created. If i put the property 'hibernate.hbm2ddl.auto' in the cfg.xml as 'create' the index is created. But in my case i have to set my property 'hibernate.hbm2ddl.auto' to update.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira