如何在Hibernate中解决带NOT NULL的循环外键约束问题

问题背景 #

使用无Spring的Hibernate 6.6.0.Final时，遭遇Store与Staff实体的循环依赖：数据库中store.manager_staff_id（NOT NULL）关联staff.staff_id，staff.store_id（NOT NULL）关联store.store_id，导致无法直接持久化任一实体，抛出TransientPropertyValueException异常。

数据库Schema（MySQL） #

store表 #

CREATE TABLE `store` (
  `store_id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `manager_staff_id` tinyint unsigned NOT NULL,
  `address_id` smallint unsigned NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`store_id`),
  UNIQUE KEY `idx_unique_manager` (`manager_staff_id`),
  KEY `idx_fk_address_id` (`address_id`),
  CONSTRAINT `fk_store_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_store_staff` FOREIGN KEY (`manager_staff_id`) REFERENCES `staff` (`staff_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

staff表 #

CREATE TABLE `staff` (
  `staff_id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(45) NOT NULL,
  `last_name` varchar(45) NOT NULL,
  `address_id` smallint unsigned NOT NULL,
  `store_id` tinyint unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `username` varchar(16) NOT NULL,
  `password` varchar(40),
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`staff_id`),
  KEY `idx_fk_store_id` (`store_id`),
  KEY `idx_fk_address_id` (`address_id`),
  CONSTRAINT `fk_staff_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_staff_store` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

实体类代码 #

Store.java #

@Entity
@Table(schema = "movie", name = "store")
public class Store {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Short id;

    @ManyToOne
    @JoinColumn(name = "manager_staff_id", nullable = false)
    private Staff mainStaff;

    @ManyToOne(cascade = {CascadeType.PERSIST, CascadeType.MERGE})
    @JoinColumn(name = "address_id", nullable = false)
    private Address address;

    @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "mainStore")
    private List<Staff> staffList;

    // Getters、Setters及其他字段
}

Staff.java #

@Entity
@Table(schema = "movie", name = "staff")
public class Staff {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Short id;

    @ManyToOne(cascade = {CascadeType.PERSIST, CascadeType.MERGE})
    @JoinColumn(name = "address_id", nullable = false)
    private Address address;

    @ManyToOne
    @JoinColumn(name = "store_id", nullable = false)
    private Store mainStore;

    @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "mainStaff")
    private List<Store> stores;

    // Getters、Setters及其他字段
}

问题描述 #

尝试持久化Store或Staff时，抛出以下异常：

java.lang.IllegalStateException: org.hibernate.TransientPropertyValueException: Not-null property references a transient value - transient instance must be saved before current operation:
Caused by: org.hibernate.TransientPropertyValueException: Not-null property references a transient value - transient instance must be saved before current operation:

循环NOT NULL外键导致无法先保存任一实体，手动保存、调整事务边界均无效。

解决方案 #

方案1：临时禁用MySQL外键检查+分步持久化 #

由于MySQL的循环NOT NULL外键无法直接插入初始数据，可临时禁用外键检查，完成插入后恢复，同时调整实体注解避免Hibernate提前校验：

步骤1：修改实体注解

移除@JoinColumn的nullable=false（仅关闭Hibernate的内存校验，数据库NOT NULL约束仍保留）：

• Store类：

  @ManyToOne
  @JoinColumn(name = "manager_staff_id") // 去掉nullable=false
  private Staff mainStaff;
  

• Staff类：

  @ManyToOne
  @JoinColumn(name = "store_id") // 去掉nullable=false
  private Store mainStore;
  

步骤2：分步持久化代码

Session session = sessionFactory.openSession();
Transaction tx = null;
try {
    tx = session.beginTransaction();

    // 临时禁用MySQL外键检查
    session.createNativeQuery("SET FOREIGN_KEY_CHECKS=0").executeUpdate();

    // 1. 先持久化依赖的Address实体
    Address address = new Address();
    // 设置address的必要字段（如street、city等）
    session.persist(address);
    session.flush();

    // 2. 持久化Store，暂不设置mainStaff
    Store store = new Store();
    store.setAddress(address);
    session.persist(store);
    session.flush(); // 获取生成的store_id

    // 3. 持久化Staff，暂不设置mainStore
    Staff staff = new Staff();
    staff.setAddress(address);
    staff.setFirstName("John");
    staff.setLastName("Doe");
    staff.setUsername("johndoe");
    staff.setActive(true);
    session.persist(staff);
    session.flush(); // 获取生成的staff_id

    // 4. 设置循环关联并更新
    store.setMainStaff(staff);
    staff.setMainStore(store);
    session.merge(store);
    session.merge(staff);

    // 恢复外键检查
    session.createNativeQuery("SET FOREIGN_KEY_CHECKS=1").executeUpdate();

    tx.commit();
} catch (Exception e) {
    if (tx != null) tx.rollback();
    throw e;
} finally {
    session.close();
}

方案2：使用@DynamicInsert+分步更新 #

若不想修改实体的nullable注解，可添加@DynamicInsert让Hibernate生成INSERT语句时忽略未设置的字段，结合外键禁用完成操作：

步骤1：给实体添加@DynamicInsert

• Store类：

  @Entity
  @Table(schema = "movie", name = "store")
  @DynamicInsert // 仅插入非空字段
  public class Store {
      // ... 原有代码
  }
  

• Staff类：

  @Entity
  @Table(schema = "movie", name = "staff")
  @DynamicInsert // 仅插入非空字段
  public class Staff {
      // ... 原有代码
  }
  

步骤2：执行持久化代码

代码逻辑与方案1一致，无需修改实体的nullable注解，@DynamicInsert会让Hibernate跳过未设置的外键字段，配合外键禁用完成插入，之后再更新关联。

注意事项 #

• 禁用外键检查仅在当前事务内生效，事务提交后恢复，不会影响其他操作。
• 必须确保最终关联设置正确，否则数据库后续的外键检查（如更新、查询）会报错。
• 若使用EntityManager而非Session，逻辑完全一致，仅需替换对应的API（如entityManager.persist()、entityManager.createNativeQuery()）。

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