I wanted to give meaningful names to my foreign keys & constraints.

Quite easy, I thought... Just add @ForeignKey on all the @ManyToOne properties that generate the foreign keys, and that's it...

But - This becomes a problem for properties inside reusable @Embeddable classes (e.g. Address)...

When several tables embed the Address component, the @ForeignKey attempts to create the same constraint name in all these tables.

This causes MYSQL to become very angry, because it requires uniqueness among all constraint names in a database.

How can I force a meaningful constraint name on fields of embeddable objects? I couldn't find a way to override the @ForeignKey definition at the 'instantiation' (@Embedded) location...

Any help would be appreciated.

Thanks,
Michael

I second the motion.

Additionally, there's nothing in the @ForeignKey annotation to enable selection of particular field in @Embeddable class, and there's nothing in @AssociationOverrides to enable it, either.

These would seem to be serious shortcomings, either on my part for not finding this in the Docs or on Hibernate's part for not addressing them in a consistent way.

Can someone from Hibernate please comment?

Thanks.

Hi,

you guys are posting on the wrong forum! This forum is only for Search, Validator, Shards.

Post you questions to the main Hibernate User Forum.

--Hardy

Acknowledged. Thank you.