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

[Diego Pires Plentz (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28251 ] 

Diego Pires Plentz commented on HHH-1012:
-----------------------------------------

>From org.hibernate.cfg.Configuration:

			/*broken, 'cos we don't generate these with names in SchemaExport
			subIter = table.getIndexIterator();
			while ( subIter.hasNext() ) {
				Index index = (Index) subIter.next();
				if ( !index.isForeignKey() || !dialect.hasImplicitIndexForForeignKey() ) {
					if ( tableInfo==null || tableInfo.getIndexMetadata( index.getFilterName() ) == null ) {
						script.add( index.sqlCreateString(dialect, mapping) );
					}
				}
			}*/

Someone knows what the meaning of  "'cos we don't generate these with names in SchemaExport"?Looking at
org.hibernate.mapping.Index.buildSqlCreateIndexString, it actually use the attribute "name" to build the "create index" script.

> Index not created by SchemaUpdate
> ---------------------------------
>
>                 Key: HHH-1012
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012
>             Project: Hibernate3
>          Issue Type: Improvement
>          Components: metamodel
>    Affects Versions: 3.2.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