Hibernate version: hibernate-3.0beta1 with hibernate-annotations-3.0alpha1

Does anyone know if there is a way to annotate a property so that when you use SchemaExport to create the database schema in the database server that it creates indexes for specified columns?

For example, I have a Person object which has firstName, middleName, and lastName properties. I want to create indexes in the database for the table columns corresponding to these properties. I can easily do this manually, but, it would be nice to have SchemaExport do it for me.

Please add this to JIRA as a new feature (In the hibernateext project)
You can also post your request to ejb3-feedback@sun.com

I posted a question regarding this to the ejb-feedback list and received the following response...

Jon,

Thanks for your feedback.

While there is some amount of db schema information included in the metadata the spec does not include any specific support for schema generation. While many O/R products support this kind of development it is not really within the purview of the EJB3 container but as you mentioned is really more appropriate for tools.

Your question indicates that we are not doing a very good job explaining what our goals are for supporting O/R mapping metadata and we will try to clarify this.

Thanks,
-Mike

> -----Original Message-----
> From: jemiller
> Sent: Wednesday, March 02, 2005 3:50 PM
> To: ejb3-edr2-feedback@sun.com
> Subject: Annotation for specifying index on column?
>
>
> As far as I can tell, there isn't a way to specify that a
> column on a table
> should have an index. I'm wondering if there are plans to add a way of
> specifying this? This would be useful for tools that read the
> information
> and create database schemas.
>
> Jon