Here is an example of DDL script generated by hibernate for a constraint and associated foreign key index for a many to one relationship.

alter table BBS_TOPICS add constraint FK17DB1ED0875D93DC foreign key (BBS_FORUMS_ID) references BBS_FORUMS;
create index IX17DB1ED0875D93DC on BBS_TOPICS (BBS_FORUMS_ID);

Is there a way to specify the name of the constraint?
Looks like there is because the Mapping examples in the reference documentation have more meaningful names.

I am using Oracle9i.

Regards,
Fran

Use the foreign-key attribute.

This undocumented attribute works fine for the constraint.

What about the name of the index?

Many Thanks,
Fran

I started to take a look at this and ended up remembering all the reasons why we removed auto-index creation from 2.0. So I got rid of that stuff again. Silly me.

Its of course always possible to add indexes by using the index attribute of the <key> mapping.