When Should I Use @JoinColumn or @JoinTable with JPA?
@JoinTable stores the id of both the table into a separate table while @JoinColumn stores id of the another table in a new column.
@JoinTable : This is the default type. Use this when you you need a more normalized database. ie. to reduce redundancy.
@JoinColumn : Use this for better performance as it does not need to join extra table.
Let's say you have an entity A
which has a @ManyToOne
association ot an entity B
@JoinColumn will define the target table Foreign Key (e.g B_ID
) while using the target Entity table (e.g. B
).
@Entity
public class A {
private Long id;
@ManyToOne
@JoinColumn(name="B_ID")
private B b;
}
@JoinTable will use a separate table to hold the relationship between A
and B
.
@Entity
public class A {
private Long id;
@ManyToOne
@JoinTable(
name = "A_B",
joinColumns = @JoinColumn(name = "B_ID"),
inverseJoinColumns = @JoinColumn(name = "A_ID")
)
private B b;
}
This time neither A
nor B
contain any Foreign Key, because there's a separate table (e.g. A_B
) to hold the association between A
and B
.
one important difference: @JoinColumn
always depends upon the context it is used:
- If the join is for a OneToOne or ManyToOne mapping using a foreign key mapping strategy, the foreign key column is in the table of the
source entity or embeddable.- If the join is for a unidirectional OneToMany mapping using a foreign key mapping strategy, the foreign key is in the table of the target entity.
- If the join is for a ManyToMany mapping or for a OneToOne or bidirectional ManyToOne/OneToMany mapping using a join table, the
foreign key is in a join table.- If the join is for an element collection, the foreign key is in a collection table.