Should Hibernate be able to handle overlapping foreign keys?

by

There is a way to bypass the validation and get it to work, thus indicating the column is a “@JoinColumnsOrFormulas” then put the solution:

Error:

@ManyToOne
@JoinColumns(value = {
    @JoinColumn(name = "country_code", referencedColumnName = "country_code"), 
    @JoinColumn(name = "zip_code", referencedColumnName = "code")})
private Zip zip = null;

@ManyToOne
@JoinColumns(value = {
    @JoinColumn(name = "country_code", referencedColumnName = "country_code", insertable = false, updatable = false),
    @JoinColumn(name = "state_code", referencedColumnName = "state_code"), 
    @JoinColumn(name = "city_name", referencedColumnName = "name")})
private City city = null;

OK:

@ManyToOne
@JoinColumns(value = {
    @JoinColumn(name = "country_code", referencedColumnName = "country_code"), 
    @JoinColumn(name = "zip_code", referencedColumnName = "code")})
private Zip zip = null;

@ManyToOne
@JoinColumnsOrFormulas(value = {
    @JoinColumnOrFormula(formula = @JoinFormula(value = "country_code", referencedColumnName = "country_code")),
    @JoinColumnOrFormula(column = @JoinColumn(name = "state_code", referencedColumnName = "state_code")),
    @JoinColumnOrFormula(column = @JoinColumn(name = "city_name", referencedColumnName = "name"))
})
private City city = null;

Regards,

More Related Contents:

  1. Mapping many-to-many association table with extra column(s)
  2. Hibernate: one-to-one lazy loading, optional = false
  3. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  4. How to use @Where in Hibernate
  5. @OrderColumn annotation in Hibernate 3.5
  6. How to query data for Primefaces dataTable using lazy loading and pagination
  7. Does the JPA specification allow references to non-primary key columns?
  8. Hibernate: comparing current & previous record
  9. Struggling to understand EntityManager proper use
  10. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  11. How to use the Java 8 LocalDateTime with JPA and Hibernate
  12. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  13. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  14. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  15. What is referencedColumnName used for in JPA?
  16. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  17. JPA/Hibernate remove entity sometimes not working
  18. Hibernate: How specify custom sequence generator class name using annotations?
  19. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  20. Deleted object would be re-saved by cascade (remove deleted object from associations)
  21. Invalidating JPA EntityManager session
  22. Hibernate ID Generator
  23. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  24. JPA CriteriaBuilder – How to use “IN” comparison operator
  25. Hibernate/JPA ManyToOne vs OneToMany
  26. Hibernate unidirectional one to many association – why is a join table better?
  27. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  28. Persist java.time.Instant (JDK8) with JPA2/Hibernate
  29. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  30. Hibernate Issue : Foreign key must have same number of columns as referenced primary key

Leave a Comment