column index

cogens · **Joined:** Sun Jun 04, 2006 8:46 am **Posts:** 13

Isn't this snippet of my mapping file supposed to create an index?

Code:

        <property
            name="name"
            type="java.lang.String"
            update="true"
            insert="true"
        >
            <column
                name="mname" 
                index="nameindex"
                not-null="true"
            />
        </property>

I use the hibernate 3.1.3 and mysql 4.1.12a.

cogens · **Joined:** Sun Jun 04, 2006 8:46 am **Posts:** 13

Calling "SchemaExportTask" from within ant creates the index,
"<property name="hbm2ddl.auto">update</property>" in hibernate.cnf.xml does not! That is odd!

max · **Posted:** Sun Jun 04, 2006 12:34 pm

schemaexport!=schemaupdate

cogens · **Joined:** Sun Jun 04, 2006 8:46 am **Posts:** 13

"Update" is the behaviour I want, so it would create the tables on first start up and only applies changes afterwarts. But with "update" the tables are created without mentioned index, whereas with "create" the tables are created with the index (but unfortunatly on each restart). Why is that?

max · **Posted:** Sun Jun 04, 2006 1:13 pm

because noone contributed that functionallity.

cogens · **Joined:** Sun Jun 04, 2006 8:46 am **Posts:** 13

max wrote:

because noone contributed that functionallity.

lol