JPA @OneToOne with Shared ID — Can I do this Better?

by

To map one-to-one association using shared primary keys use @PrimaryKeyJoinColumn and @MapsId annotation.

Relevant sections of the Hibernate Reference Documentation:

PrimaryKeyJoinColumn

The PrimaryKeyJoinColumn annotation does say that the primary key of
the entity is used as the foreign key value to the associated entity.

MapsId

The MapsId annotation ask Hibernate to copy the identifier from
another associated entity. In the Hibernate jargon, it is known as a
foreign generator but the JPA mapping reads better and is encouraged

Person.java

@Entity
public class Person {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "person_id")
    private Long id;

    @OneToOne(cascade = CascadeType.ALL)
    @PrimaryKeyJoinColumn
    private VitalStats vitalStats;       
}

VitalStats.java

@Entity
public class VitalStats 
{
    @Id @Column(name="vitalstats_id") Long id;

    @MapsId 
    @OneToOne(mappedBy = "vitalStats")
    @JoinColumn(name = "vitalstats_id")   //same name as id @Column
    private Person person;

    private String stats;
}

Person Database Table

CREATE TABLE  person (
  person_id   bigint(20) NOT NULL auto_increment,
  name        varchar(255) default NULL,
  PRIMARY KEY  (`person_id`)
)

VitalStats Database Table

CREATE TABLE  vitalstats 
(
  vitalstats_id  bigint(20) NOT NULL,
  stats          varchar(255) default NULL,
  PRIMARY KEY  (`vitalstats_id`)
)

More Related Contents:

  1. How can I make a JPA OneToOne relation lazy
  2. Java: Hibernate @OneToOne mapping
  3. How to return a custom object from a Spring Data JPA GROUP BY query
  4. Mapping PostgreSQL JSON column to a Hibernate entity property
  5. How to choose the id generation strategy when using JPA and Hibernate
  6. Using generics in Spring Data JPA repositories
  7. JPQL Create new Object In Select Statement – avoid or embrace?
  8. Hibernate, @SequenceGenerator and allocationSize
  9. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  10. “detached entity passed to persist error” with JPA/EJB code
  11. JPA/Hibernate Native Queries do not recognize Parameters
  12. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  13. @Transactional method called from another method doesn’t obtain a transaction
  14. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  15. Spring – Is it possible to use multiple transaction managers in the same application?
  16. JPA getSingleResult() or null
  17. JPA how to make composite Foreign Key part of composite Primary Key
  18. Spring JPA @Query with LIKE
  19. Hibernate/JPA DB Schema Generation Best Practices
  20. How to set a default query timeout with JPA and Hibernate?
  21. Java Enums, JPA and Postgres enums – How do I make them work together?
  22. Difference between a “jta-datasource” and a ” resource-local ” datasource?
  23. use of entityManager.createNativeQuery(query,foo.class)
  24. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  25. Persisting UUID in PostgreSQL using JPA
  26. JpaRepository caches newly created object. How to refresh it?
  27. Batch inserts with JPA/EJB3
  28. database sort vs. programmatic java sort
  29. JPA Criteria Tutorial [closed]
  30. Is EntityManager really thread-safe?

Leave a Comment