Problem:
Need to create a join table in database using JPA annotations so the DATABASE design as follows:
Solution:
Default entities implementation:
@Entity
@Table(name="USER")
public class User implements Serializable {
//...
@ManyToOne
@JoinTable(name="USER_GROUP")
Group group;
@Entity
@Table(name="GROUP")
public class Group implements Serializable {
//...
@OneToMany(mappedBy="group")
Set<User> users;
Changes on User entity as follows:
@Entity @Table(name="USER") public class User implements Serializable { //...@ManyToOne @JoinTable(name="USER_GROUP", joinColumns = @JoinColumn(name = "user_id", referencedColumnName = "user_id"), inverseJoinColumns = @JoinColumn(name = "group_id", referencedColumnName = "group_id")) Group group;
No comments:
Post a Comment