Hibernate PostgreSQL OneToOne关系首先触发子查询

Question

我正在开发应用程序来学习PostgreSQL上的HiberNate。我目前正在尝试将变量添加到具有OneToOne关系的数据库中。

首先，我用下面的模式在数据库中创建了两个表。在person\u detail表上，它有主键，也是person表的外键。

然后我创建了两个类，Person和人格化细节。人格化细节是具有OneToOne关系的Person的子类。我使用下面的代码添加人格化细节作为属性的人。

Person person = new Person(
        "Rick",
        1.7,
        dateFromString("1969-4-2"),
        new Date()
);
PersonDetail personDetail =
        new PersonDetail("[e-mail]", "Marley");
person.setPersonDetail(personDetail);

session.beginTransaction();

session.save(person);
session.save(personDetail);

session.getTransaction().commit();

System.out.println(person.toString());

但是上面代码的问题是HiberNate首先执行子查询，而不是父查询。

Hibernate：在person_详细信息（地址、电子邮件）中插入值（？，）

由于person仍然为空，我们无法在person\u detail中插入任何行，因为它违反了外键约束。

有办法解决这个问题吗？谢谢

如果有人想检查我是如何注释这两个类的，我会把代码放在下面。

@Entity
@Table(name="person")
@Data
public class Person {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="id")
    private int id;

    @Column(name="name")
    private String name;

    @Column(name="height")
    private double height;

    @Column(name="birth_date")
    private Date dateBirth;

    @Column(name="last_seen")
    private Date lastSeen;

    @OneToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "id")
    private PersonDetail personDetail;

    public Person() {}

    public Person(String name, double height, Date dateBirth, Date lastSeen){
        this.name = name;
        this.height = height;
        this.dateBirth = dateBirth;
        this.lastSeen = lastSeen;
    }
}


@Data
@Entity
@Table(name="person_detail")
public class PersonDetail {
    @Id
    @Column(name="id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(name="email")
    private String email;

    @Column(name="address")
    private String address;

    public PersonDetail(){}

    public PersonDetail(String email, String address){
        this.email = email;
        this.address = address;
    }
}

Answer 1

我看到你有主键在表person_details作为外键到人表，你可以使用@PrimaryKeyJoin列像这样：

@Entity
@Table(name="person")
@Data
public class Person {

    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "name")
    private String name;

    @Column(name = "height")
    private String height;

    @OneToOne(mappedBy = "person", cascade = CascadeType.ALL)
    @PrimaryKeyJoinColumn
    private PersonDetail personDetail;

    public Person() {}

    public Person(String name, String height) {
        this.name = name;
        this.height = height;
    }
}

@Data
@Entity
@Table(name="person_detail")
public class PersonDetail {

    @Id
    @Column(name="id")
    private Long id;

    @Column(name="email")
    private String email;

    @OneToOne
    @MapsId
    @JoinColumn(name = "id", referencedColumnName = "id")
    private Person person;


    public PersonDetail(){}

    public PersonDetail(String email){
        this.email = email;
    }
}

如果保存实体，不要忘记将Person设置为PersonDetails：

Person person = new Person("Rick", "1.7");
        
PersonDetail personDetail = new PersonDetail("[e-mail]");
personDetail.setPerson(person);

person.setPersonDetail(personDetail);
        
repository.save(person);