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

[Erik G (JIRA)]

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

Erik G commented on HHH-1012:
-----------------------------

Christian, thanks for the pointer. I would like to get SchemaUpdate to generate the indexes the same way SchemaExport does. Seems like the patch on this issue would work but needs to have an accompanying unit test to make sure nothing gets broken. I'm happy to create the testcase if one ws never built, I just need a pointer to what test cases already exist for modifcations to SchemaUpdate.

> index not created by SchemaUpdate
> ---------------------------------
>
>          Key: HHH-1012
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012
>      Project: Hibernate3
>         Type: Bug

>     Versions: 3.1 beta 1, 3.1 beta 2, 3.0.5
>  Environment: Windows XP, MySQL/PostgreSQL
>     Reporter: Xavier Farret
>     Priority: Minor
>  Attachments: Indexes.patch
>
>
> 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