Does the JPA specification allow references to non-primary key columns?

by

@axtavt: It appears as if your answer wasn’t correct. I’ve just received an email from the authors of “Pro JPA 2.0”, who were also working on the JPA spec themselves.

“In your example the Zip class has a relationship to a Country:

public class Zip implements Serializable
{
    @Id
    @Column(name = "code")
    private String code;

    @Id
    @ManyToOne
    @JoinColumn(name = "country_code", referencedColumnName = "iso_code")
    private Country country = null;
    ...
}

This appears to be trying to point the country_code foreign key column to the iso_code column in the Country table, which is not a PK. JPA has never allowed you to create a relationship like this because without specifying the PK of the Country
there would be no way to uniquely identify which Country instance is in the relationship. You are simply hitting the problem when you get to the derived identifier part, but the problem looks to be in the invalid relationship itself.”

So the JPA spec doesn’t allow relationships/FKs to non-PK columns at all…

More Related Contents:

  1. Mapping many-to-many association table with extra column(s)
  2. How to generate Custom Id using hibernate while it must be primary key of table
  3. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  4. JPA 2.0 many-to-many with extra column
  5. How to mix inheritance strategies with JPA annotations and Hibernate?
  6. How to use @Where in Hibernate
  7. @OrderColumn annotation in Hibernate 3.5
  8. How to query data for Primefaces dataTable using lazy loading and pagination
  9. Hibernate: comparing current & previous record
  10. Struggling to understand EntityManager proper use
  11. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  12. How to use the Java 8 LocalDateTime with JPA and Hibernate
  13. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  14. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  15. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  16. What is referencedColumnName used for in JPA?
  17. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  18. JPA/Hibernate remove entity sometimes not working
  19. Hibernate: How specify custom sequence generator class name using annotations?
  20. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  21. Deleted object would be re-saved by cascade (remove deleted object from associations)
  22. Hibernate ID Generator
  23. JPA Uppercase table names
  24. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  25. JPA CriteriaBuilder – How to use “IN” comparison operator
  26. inverse=true in JPA annotations
  27. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  28. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  29. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  30. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus

Leave a Comment