How to create join table with JPA annotations?

by

You definitely shouldn’t create User_Group entity as it’s more the underlying database representation than the object oriented one.

You can achieve the join table by defining something like:

@Entity
@Table(name="USERS", schema="ADMIN")
public class User implements Serializable {
//...

@ManyToOne
@JoinTable(name="USER_GROUP")
Group group;

@Entity
@Table(name="GROUPS", schema="ADMIN")
public class Group implements Serializable {
//...

@OneToMany(mappedBy="group")
Set<User> users;

Edit: If you want to explicitly set the names of the columns you could use @JoinColumn elements as shown below:

@ManyToOne
@JoinTable(name="USER_GROUP",
    joinColumns = @JoinColumn(name = "userid", 
                              referencedColumnName = "userid"), 
    inverseJoinColumns = @JoinColumn(name = "groupid", 
                              referencedColumnName = "groupid"))
Group group;

More Related Contents:

  1. What’s the difference between JPA and Hibernate? [closed]
  2. Can someone explain mappedBy in JPA and Hibernate?
  3. When and why JPA entities should implement the Serializable interface?
  4. Why does JPA have a @Transient annotation?
  5. JPQL Create new Object In Select Statement – avoid or embrace?
  6. How to annotate MYSQL autoincrement field with JPA annotations
  7. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  8. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  9. JPA/Hibernate Native Queries do not recognize Parameters
  10. How to persist a property of type List in JPA?
  11. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  12. What is the easiest way to ignore a JPA field during persistence?
  13. Hibernate and no PK
  14. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  15. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  16. JPA map collection of Enums
  17. How can I use hibernate with MS Access?
  18. Is there such thing CASE expression in JPQL?
  19. JPA Criteria builder IN clause query
  20. Is it possible to dynamically define column names in Hibernate / JPA?
  21. @Basic(optional = false) vs @Column(nullable = false) in JPA
  22. How to map a map JSON column to Java Object with JPA
  23. Difference between a “jta-datasource” and a ” resource-local ” datasource?
  24. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  25. Hibernate, spring, JPS & isolation – custom isolation not supported
  26. Batch inserts with JPA/EJB3
  27. What’s the difference between the IN and MEMBER OF JPQL operators?
  28. Change Table Name of an Entity on runtime? [duplicate]
  29. How to auto detect entities in JPA 2.0
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment