How to reverse engineer indices?

fy · **Joined:** Mon Oct 31, 2005 3:30 pm **Posts:** 3

Hibernate Tools version: 3.1.0 Beta1
MySQL connector version: 3.1.11

I have an existing MySQL catalog which contains serveral tables, each of which has some indices. But when I try to reverse engineer these tables to EJB3 annotated entities from inside Eclipse, I could NOT find any indices are actually annotated in the generated code, while unique constraints were properly done. Am I missing something?

Thanks a ton,

FY

max · **Posted:** Mon Oct 31, 2005 4:44 pm

no, but its probably just not added to the ejb3 annotation support.

add a request to jira.

btw. what do you want them for if you already have the db ?

fy · **Joined:** Mon Oct 31, 2005 3:30 pm **Posts:** 3

Well, since we want to support multiple databases, so ideally, if we can use EJB3/Hibernate annotations to generate/export database schemas for various databases without touching sql scripts, it will tremendously speed up our packaging and deployment. Otherwise, we still have to manually maintain those scripts and synchronize with annotations, which is a bit hassle.

But why constraints are implemented, not indices?

Thanks,

FY

max · **Posted:** Tue Nov 01, 2005 10:29 am

because we prioritize our work ? ;)

add a jira request for it or even better add the support your self and get it immediatly.