Hibernate未设置外键

Question

我有这个型号

public class Customer {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;

@OneToOne
@PrimaryKeyJoinColumn
private Address registred_address_id;

@OneToOne
@PrimaryKeyJoinColumn
private Address actual_address_id;
...

而我有这个方法

private Customer addCustomer(String first_name, String last_name, String middle_name, String sex, Address address) {
    Customer customer = new Customer(first_name, last_name, middle_name, sex);
    customer.setActual_address_id(address);
    customer.setRegistered_address_id(address);
    customerRepo.save(customer);
    return customer;
}

但是hibernate没有设置实际地址id和注册地址id（它是OneTONE）

Hibernate：插入客户（名字、姓氏、中间名、性别）值（？、、？、？）2021-03-18 14:01:58.340警告12836---[nio-8080-exec-1]o.h.发动机。jdbc。spi。SqlExceptionHelper:SQL错误：0，SQLState:23502 2021-03-18 14:01:58.340错误12836---[nio-8080-exec-1]o.h.engine。jdbc。spi。SqlExceptionHelper:ББББА：空值：注册地址id：客户非空值（6，空值，空值，空值，空值，男性）。

Answer 1

你的映射是矛盾的。

从一个侧面看，您需要客户。插入后由数据库生成的id。这就是GenerationType。身份实际上意味着什么。

另一方面，您尝试使用@PrimaryKeyJoinColumn什么是客户。id应通过地址设置。id。@PrimaryKeyJoinColumn的正确映射应如下所示：

@Entity
public class Customer {

  @Id
  private long id;

  @OneToOne
  @PrimaryKeyJoinColumn
  private Address address;
 
  public void setAddress(Address address) {
     this.address = address;
     this.id = address.getId();
  }
  // ... 
}

但这不符合你的要求。

因此，我建议您按照以下方式更正客户表：

create table customer
(
   id bigserial not null,
   reg_address_id bigint,
   act_address_id bigint,
   -- ...
   primary key(id),
   foreign key(reg_address_id) references address(id),
   foreign key(act_address_id) references address(id)
);

然后使用以下映射：

@Entity
public class Customer {

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

  @OneToOne
  @JoinColumn(name = "reg_address_id")
  private Address registredAddress;

  @OneToOne
  @JoinColumn(name = "act_address_id")
  private Address actualAddress;

  // ... 
}