I just found out that officially relationships/foreign keys to non-primary key columns aren't supported by JPA. See here:

http://stackoverflow.com/questions/5818 ... ey-columns

Why do such relationships map in Hibernate nontheless (only in JPA 1.0 syntax as in the example posted there)??

It appears that Hibernate just maps the columns naively, which I think is a good thing, but I'd like to know explicitly. Is it coincidence? Is it intended? Is there anything in the docs where it supports this scenario?

Karsten

The only thing I found in the docs is this:

http://docs.jboss.org/hibernate/stable/ ... ssociation


So Hibernate basically supports these relationships with limitations to single-column FKs.

Karsten