Hello,

is it possible to create indices when exporting the database schema with hbm2dll.auto-option the using the lates version of Hibernate with JPA?

At the moment I am still developing a Hibernate based application and nearly every day I have to add another column to my database. Therefore I am using the hbm2dll.auto-option. And as there will be a lot of data in the database I have to add some indices to the tables with more than 1.000.000 entries. I would like to do this in my code - by hand is also possible but it would be more convenient to do it in the code. Is this possible somehow?

Regards and thanks,
Dominik

It depends on what you mean by "in the code". If you mean hbm, I guess yes. Did you try using the index attribute on the property tag?

See the reference documentation: http://www.hibernate.org/hib_docs/v3/re ... guide.html

Thanks for the responce. Perhaps I didn't mention that I am using Hibernate in a JPA environment. That means that I am using JPA-Annotations to define the mapping... That means I don't have a hbm-file. But I will have a look at hibernate annotations - I think I'll have more possibilities there.