Spring Data JPA非主键字段外键关联映射配置方法

JPA实现非主键关联有两个强制要求，你的配置均不满足，导致框架回退到默认主键关联逻辑：

1. 被关联的非主键字段必须配置唯一约束，否则JPA不认可该字段为合法关联目标
2. 配置存在字段、列名不匹配问题：CurriculumVitae实体中未定义family_member_id字段，仅存在String类型的familyMember字段，和@JoinColumn声明的关联字段无法对应，配置直接失效。

1. 调整CurriculumVitae实体配置 #

新增对应关联字段、加唯一约束，修正@OneToMany的关联映射参数，其余普通业务字段保持原有逻辑不变即可：

@Getter
@Setter
@ToString
@Data
@Entity
@Table(name = "CurriculumVitaes")
public class CurriculumVitae implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    // 新增两个关联字段，配置唯一约束，类型和关联表主键类型一致（Long）
    @Column(name = "event_id", unique = true)
    private Long eventId;

    @Column(name = "family_member_id", unique = true)
    private Long familyMemberId;

    // 原有普通字段（identityCardNumber、phoneNumber、ethnic等）全部保留，删除原来定义的String类型familyMember字段避免冲突

    @OneToMany(mappedBy = "curriculumVitae", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @EqualsAndHashCode.Exclude
    @ToString.Exclude
    @JsonIgnore
    private Collection<Event> event;

    // 修正FamilyMember的一对多关联映射，明确指定关联字段对应关系
    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JoinColumn(name = "id", referencedColumnName = "family_member_id")
    @EqualsAndHashCode.Exclude
    @ToString.Exclude
    @JsonIgnore
    private Collection<FamilyMember> familyMemberList;
}

2. 调整FamilyMember实体配置 #

修正@ManyToOne的@JoinColumn参数，因为外键存储在CurriculumVitae表，当前实体不需要维护外键的增改：

@Getter
@Setter
@ToString
@Data
@Entity
@Table(name = "FamilyMembers")
public class FamilyMember implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    // 原有普通字段（name、occupation、augustRevolution等）全部保留

    @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    @JoinColumn(name = "id", referencedColumnName = "family_member_id", insertable = false, updatable = false)
    @EqualsAndHashCode.Exclude
    @ToString.Exclude
    private CurriculumVitae curriculumVitae;
}

3. 调整Event实体配置 #

和FamilyMember逻辑一致，修正多对一关联参数：

@Getter
@Setter
@ToString
@Data
@Entity
@Table(name = "Events")
public class Event implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    // 原有Event自身业务字段全部保留

    @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    @JoinColumn(name = "id", referencedColumnName = "event_id", insertable = false, updatable = false)
    @EqualsAndHashCode.Exclude
    @ToString.Exclude
    private CurriculumVitae curriculumVitae;
}

• 如果是已经初始化过表结构的环境，需要先删除表中原有自动生成的错误外键约束，再重启应用加载新的映射配置，否则会报外键冲突
• 不要去掉family_member_id、event_id字段的unique = true配置，这是JPA非主键关联的必要条件，去掉后会再次回退到主键关联逻辑
• 关联字段的类型必须和对应表的主键类型完全一致，不能用String类型存储Long类型的主键ID，否则会报类型不匹配异常

内容的提问来源于stack exchange，提问作者Nguyen The Toan