JPA复合主键一对一映射问题：Person关联PersonDetail失败

针对你的场景（Person和PersonDetail一对一关联、均使用复合主键，PersonDetail主键多lanCode字段），以下是正确的实体映射配置步骤：

1. 定义复合主键类 #

复合主键类必须实现Serializable，并重写equals()和hashCode()方法，确保主键唯一性判断逻辑正确。

PersonId.java（Person的复合主键） #

import java.io.Serializable;
import java.util.Objects;

public class PersonId implements Serializable {
    private String personCode;
    private String regCode;

    // JPA要求必须提供无参构造
    public PersonId() {}

    public PersonId(String personCode, String regCode) {
        this.personCode = personCode;
        this.regCode = regCode;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        PersonId personId = (PersonId) o;
        return Objects.equals(personCode, personId.personCode) && Objects.equals(regCode, personId.regCode);
    }

    @Override
    public int hashCode() {
        return Objects.hash(personCode, regCode);
    }

    // 必须提供getter/setter方法
    public String getPersonCode() { return personCode; }
    public void setPersonCode(String personCode) { this.personCode = personCode; }
    public String getRegCode() { return regCode; }
    public void setRegCode(String regCode) { this.regCode = regCode; }
}

PersonDetailId.java（PersonDetail的复合主键） #

import java.io.Serializable;
import java.util.Objects;

public class PersonDetailId implements Serializable {
    private String personCode;
    private String regCode;
    private String lanCode;

    public PersonDetailId() {}

    public PersonDetailId(String personCode, String regCode, String lanCode) {
        this.personCode = personCode;
        this.regCode = regCode;
        this.lanCode = lanCode;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        PersonDetailId that = (PersonDetailId) o;
        return Objects.equals(personCode, that.personCode) && Objects.equals(regCode, that.regCode) && Objects.equals(lanCode, that.lanCode);
    }

    @Override
    public int hashCode() {
        return Objects.hash(personCode, regCode, lanCode);
    }

    // getter/setter方法
    public String getPersonCode() { return personCode; }
    public void setPersonCode(String personCode) { this.personCode = personCode; }
    public String getRegCode() { return regCode; }
    public void setRegCode(String regCode) { this.regCode = regCode; }
    public String getLanCode() { return lanCode; }
    public void setLanCode(String lanCode) { this.lanCode = lanCode; }
}

2. 配置PersonDetail实体（关联拥有方） #

你已实现通过PersonDetail查询Person，这里补全标准配置：

import jakarta.persistence.*;

@Entity
@IdClass(PersonDetailId.class) // 指定复合主键类
public class PersonDetail {
    @Id
    private String personCode;
    @Id
    private String regCode;
    @Id
    private String lanCode;

    // 关联Person，作为关联关系的拥有方
    @OneToOne
    @JoinColumns({
            @JoinColumn(name = "person_code", referencedColumnName = "person_code", insertable = false, updatable = false),
            @JoinColumn(name = "reg_code", referencedColumnName = "reg_code", insertable = false, updatable = false)
    })
    private Person person;

    // 示例业务字段
    private String address;

    // getter/setter方法
    public String getPersonCode() { return personCode; }
    public void setPersonCode(String personCode) { this.personCode = personCode; }
    public String getRegCode() { return regCode; }
    public void setRegCode(String regCode) { this.regCode = regCode; }
    public String getLanCode() { return lanCode; }
    public void setLanCode(String lanCode) { this.lanCode = lanCode; }
    public Person getPerson() { return person; }
    public void setPerson(Person person) { this.person = person; }
    public String getAddress() { return address; }
    public void setAddress(String address) { this.address = address; }
}

3. 配置Person实体（关联方） #

核心解决Person无lanCode字段却要关联PersonDetail的问题，通过@JoinColumnsOrFormulas明确指定所有关联条件，避免JPA自动推断SQL出错：

import jakarta.persistence.*;

@Entity
@IdClass(PersonId.class)
public class Person {
    @Id
    private String personCode;
    @Id
    private String regCode;

    // 关联PersonDetail，指定完整连接条件
    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumnsOrFormulas({
            // 匹配Person和PersonDetail的共同主键字段
            @JoinColumnOrFormula(column = @JoinColumn(name = "person_code", referencedColumnName = "person_code")),
            @JoinColumnOrFormula(column = @JoinColumn(name = "reg_code", referencedColumnName = "reg_code")),
            // 指定lanCode取值：这里用固定值示例，可根据业务调整为Person的字段关联
            @JoinColumnOrFormula(formula = @JoinFormula(value = "'zh-CN'", referencedColumnName = "lan_code"))
    })
    private PersonDetail personDetail;

    // 示例业务字段
    private String name;

    // getter/setter方法
    public String getPersonCode() { return personCode; }
    public void setPersonCode(String personCode) { this.personCode = personCode; }
    public String getRegCode() { return regCode; }
    public void setRegCode(String regCode) { this.regCode = regCode; }
    public PersonDetail getPersonDetail() { return personDetail; }
    public void setPersonDetail(PersonDetail personDetail) { this.personDetail = personDetail; }
    public String getName() { return name; }
    public void setName(String name) { this.name = name; }
}

关键调整说明 #

• 如果业务中每个Person对应的lanCode不是固定值，而是存储在Person的普通字段中，可将@JoinFormula替换为@JoinColumn：

  @JoinColumnOrFormula(column = @JoinColumn(name = "lan_code", referencedColumnName = "lan_code"))
  

• 确保@JoinColumn中的name对应Person表字段，referencedColumnName对应PersonDetail表字段，大小写需与数据库字段一致。
• 复合主键类必须正确重写equals()和hashCode()，否则会触发主键匹配异常。

内容的提问来源于stack exchange，提问作者iCode