I have this setting in the hibernate.cfg.xml


<property name="hibernate.hbm2ddl.auto">update</property>

and defined a class like this



I want to create the table at the start of the process.

But If I don't put the javax.persistence annotation, I get an exception telling me that table points to an unknown table.

Also I'd like to create the table with the columns in that order. but the table is generated with its columns in alphabetical order. (If it's pre-generated the order is respected,but I don't have that posibility)

Also Indexes are not being created.

What could be happening here?

I use Hibernate annotations 3.4.0.GA and Mysql 5.1.46

Hi

Run your code with debug log level you will then see what Hibernate is doing. Post the log if you want.

I tried your example and my setup works correctly.

My columns were created in the order defined in the Entity class. Order in which columns are created can be affected by few things:
a. what ever is generating create sql statement might be ordering the column. Need to check the API for Hibernate
b. database could be configured to place columns in the alphabetical order ( not sure if this can be done in mysql but is possible) but I reckon your issue is due to (a) above. Find out which class creates the schema and see if there is any property to turn this off.

I am using Spring3 with Hibernate EntityManager 3.2.1.GA.

In my environment everything worked as you were expecting including the index creation.


Also check mysql user has permission to create indexes.

<property name="hibernate.hbm2ddl.auto">create</property> then only in Database create table and <mapping class="<pojo class or(table name)>"> use this property.