Spring数据映射不按预期工作

Question

我有一个具有两个外键和多对一关联（到表、检查点和设置）的表选项：db Schema。

@Entity
@Table(name = "checkpoint")
@AllArgsConstructor
@NoArgsConstructor
@Data
html" target="_blank">public class Checkpoint {

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

  private long location;

  @OneToMany(mappedBy = "checkpoint",
        cascade = CascadeType.ALL,
        orphanRemoval = true,
        fetch = FetchType.EAGER)
  private List<RewardOption> rewardOptions = new ArrayList<>();
}

@Entity
@Table(name = "setting")
@AllArgsConstructor
@NoArgsConstructor
@Data
public class RewardSetting {

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

  @Column(name = "base_line")
  private long baseLine;

  @OneToMany(mappedBy = "rewardSetting",
        cascade = CascadeType.REMOVE,
        orphanRemoval = true)
  private List<RewardOption> rewardOptions = new ArrayList<>();
}

@Entity
@Table(name = "option")
@AllArgsConstructor
@NoArgsConstructor
@Data
public class RewardOption {

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

  private long weight;

  @ManyToOne
  @JoinColumn(name = "setting_id")
  private RewardSetting rewardSetting;

  @ManyToOne
  @JoinColumn(name = "checkpoint_id")
  private Checkpoint checkpoint;
} 

...
rewardSettingRepository.delete(rewardSetting);

...
rewardSettingRepository.delete(id);

完整堆栈跟踪是：

org.springframework.dao.DataIntegrityViolationException：不能执行语句；SQL[N/A]；约束[null]；嵌套异常是org.hibernate.exception.constraintViolationException：在org.springframework.orm.jpa.vendor.hibernatejpaction.converthibernateAccessException（Hibernatejpaction.java:278)在org.springframework.orm.jpa.vendor.hibernatejpaction.java.translateExceptionIfprobley（Hibernatejpaction.java:244)在manager.java:765)在org.springframework.transaction.support.AbstractPlatformTransactionManager.Commit（AbstractPlatformTransactionManager.java:734)在org.springframework.transaction.interceptor.transaction.Transaction.Transaction.Transaction.Transaction.Transaction.TransactionSupport.CommittTransactionAfterRetting（interceptor.transactioninterceptor.invoke（transactioninterceptor.java:96)在org.springframework.aop.framework.reflectiveMethodInvocation.proce(reflectiveMethodInvocation.java:179)在org.springframework.dao.support.persistenceExceptionTranslationInterceptor.invoke在（CrudMethodMetadatapostProcessor.java:133)在org.springframework.aop.framework.reflectiveMethodInvocation.java:179)在org.springframework.aop.interceptor.exposeInvocation.invokor.invoke(exposeInvocation.java:92)在org.springframework.aop.framework.refository.core.support.surrou在ndingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)在org.springframework.aop.framework.ReflectiveMethodInvocation.proce(ReflectiveMethodInvocation.java:179)在UB.star67.hibernateFetchCascade.hibernateFetchCascadeApplication.main(HibernateFetchCascadeApplication.java:36)

由：org.hibernate.exception.constraintViolationException：在org.hibernate.exception.internal.sqlExceptionTypeDelegate.convert(sqlExceptionTelegate.java:59)在org.hibernate.exception.internal.standardsqlExceptionConverter.convert(StandardsqlExceptionConverter.java:42)在org.hibernate.engine.jdbc.spi.sqlExceptionConvert ResultsetReturnImpl.java:207)在org.hibernate.engine.jdbc.batch.internal.nonbatchingBatch.addTobatch（nonbatchingBatch.java:45)在org.hibernate.persister.entity.AbstractEntityPersister.delete（AbstractEntityPersister.delete）在org.hibernate.persister.entity.AbstractEntityPersister.delete（i.actionQueue.executeAction(actionQueue.java:582)在org.hibernate.engine.spi.actionQueue.executeAction(actionQueue.java:456)在org.hibernate.event.internal.abstractFlushingEventListener.performExecutions(abstractFlushEventListener.java:337)在org.hibernate.event.internal.defaultFlushEventListener.onflush在org.hibernate.internal.sessionimpl.beforeTransactionCompletis(sessionimpl.java:2963)在org.hibernate.engine.jdbc.internal.jdbc.internal.jdbc.c.internal.jdbcCoordinatorimpl.beforeTransactionCompletis(sessionimpl.java:2339)在nsaction.backend.jdbc.internal.jdbcResourceLocalTransactionCoordinatorImpl.Access$100(jdbcResourceLocalTransactionCoordinatorImpl.java:38)在org.hibernate.resource.transaction.backend.jdbc.internal.jdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlimpl.Commit pa.jpatransactionManager.doCommit(jpatransactionManager.java:517)...18多

由:java.sql.sqlintegrityConstraintViolationException:无法删除或更新父行：外键约束失败(演示.选项,约束fkdhs5wopt13o6b9gl4wydr0l9o外键(setting_id)引用设置(id))在.mysql.cj.jdbc.exceptions.sqlexceptionsmapping.translateExceptionsmapping.java:122)在com.mysql.cj.jdbc.clientPreparedStatement.executeInternal（ClientPreparedStatement.java:960)在com.mysql.cj.jdbc.clientPreparedStatement.executeUpdateInternal（ClientPreparedStatement.java:1116)在1396）在com.mysql.cj.jdbc.clientpreparedStatement.executeUpdate（ClientPreparedStatement.java:1051)在sun.reflect.nativeMethodAccessorImpl.invoke0（原生方法）在sun.reflect.nativeMethodAccessorImpl.invoke（nativeMethodAccessorImpl.invoke（nativeMethodAccessorImpl.java：62）在sun.reflect.delegatingMethodAccessorImpl.invoke（delegatingMethodAccessorImpl.java hibernate.engine.jdbc.internal.ResultSetReturnImpl.ExecuteUpdate(resultSetReturnImpl.java:204)...37多

而且，在玩了一圈之后，我发现了一些奇怪的事情，我无法解释：

1. 在类RewardOption中为检查点添加@manytoone(fetch=FetchType.lazy)可以解决这个问题，但是fetch类型如何影响级联？
2. 在类检查点中更改cascade=cascadetype.all to cascade=cascadetype.remove可以解决这个问题，但是我需要保存cascade...

如果有人能对这些“修复”有所了解，那就太好了。

以下是可供使用的代码

Answer 1

要使其工作，您需要同步双向关联的两端。

这意味着，在调用delete之前，您需要确保将父实体与al子实体分离。