JPA/HIbernate integrity constraint violated on cascade

Question

i具有以下实体，该实体与WorkflowDetail类有关系：

@Entity()
@DynamicUpdate()
@Table(schema = "RACQUISTI", name = "RICHIESTA_DI_ACQUISTO")
public class RichiestaDiAcquisto {
   @Id
   @Column(name = "ID_RICHIESTA_ACQUISTO")
   @SequenceGenerator(name="SEQ_GEN",sequenceName="RICHIESTA_DI_ACQUISTO_SEQ",   allocationSize=1)
   @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SEQ_GEN")
   private int id;
   @OneToOne(fetch=FetchType.LAZY, cascade = {CascadeType.ALL})
   @JoinColumn(name="ID_RICHIESTA_ACQUISTO")
   private WorkFlowDetail workFlowDetail;
  .....
}

WorkFlowDetail实体是：

@Entity()
@Table(schema = "RACQUISTI", name = "WORKFLOW_DETAIL")
public class WorkFlowDetail {
   @Id
   @Column(name = "ID_RICHIESTA_ACQUISTO")
   private int idRichiestaDiAcquisto;
   @Column(name = "ID_WORKFLOW_INSTANCE")
   private String idWorkFlowInstance;
   ....
}

表工作flow_detail在Richiesta_di_acquisto主键上有一个外键。

执行以下代码时：

RichiestaDiAcquisto entity = new RichiestaDiAcquisto();
getSession().saveOrUpdate(entity);

我收到此错误：

Hibernate: select RICHIESTA_DI_ACQUISTO_SEQ.nextval from dual
Hibernate: select workflowde_.ID_RICHIESTA_ACQUISTO,    workflowde_.CURRENT_NODE_ID as CURRENT_2_2_, workflowde_.DATA_MOD as DATA_MOD3_2_, workflowde_.ID_WORKFLOW_INSTANCE as ID_WORKF4_2_, workflowde_.WORKFLOW_TOKEN as WORKFLOW5_2_ from RACQUISTI.WORKFLOW_DETAIL workflowde_ where workflowde_.ID_RICHIESTA_ACQUISTO=?
Hibernate: select richiedent_.ID_RICHIESTA_ACQUISTO, richiedent_.COGNOME as   COGNOME2_0_, richiedent_.GODIVA_ANAGRAFICA_ID as GODIVA_A3_0_, richiedent_.NOME as NOME4_0_ from RACQUISTI.RICHIEDENTE richiedent_ where richiedent_.ID_RICHIESTA_ACQUISTO=?
Hibernate: insert into RACQUISTI.RICHIESTA_DI_ACQUISTO (ACQUISTO_DI_BENI, CONFERMA_CAPITOLO, CONFERMA_ELEGIBILITA, COSTO_ACQUISTO, DATA_MOD, DESCRIZIONE_ACQUISTO, GARA_NAZIONALE_CATALOGO, ID_ANAG_MOD, LUOGO_DI_CONSEGNA, SIGLA_ESPERIMENTO, STATUS, STRUTTURA_PAGANTE, ID_RICHIESTA_ACQUISTO) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into RACQUISTI.WORKFLOW_DETAIL (CURRENT_NODE_ID, DATA_MOD, ID_WORKFLOW_INSTANCE, WORKFLOW_TOKEN, ID_RICHIESTA_ACQUISTO) values (?, ?, ?, ?, ?)
WARN    2017-04-28 10:14:28,817 [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - SQL Error: 2291, SQLState: 23000
ERROR   2017-04-28 10:14:28,819 [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ORA-02291: integrity constraint (RACQUISTI.WORKFLOW_DETAIL_FK1) violated - parent key not found

Answer 1

您的插入语句试图将一个值插入列中不存在的列

Answer 2

我找到了一个解决方案。我修改了主要班级儿童的注释(WorkFlowDetail(：

@Entity()
@DynamicUpdate()
@Table(schema = "RACQUISTI", name = "RICHIESTA_DI_ACQUISTO")
public class RichiestaDiAcquisto {
 @Id
 @Column(name = "ID_RICHIESTA_ACQUISTO")     
 @SequenceGenerator(name="SEQ_GEN",sequenceName="RICHIESTA_DI_ACQUISTO_SEQ",   allocationSize=1)
 @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SEQ_GEN")
 private int id;
 @OneToOne(fetch=FetchType.LAZY, mappedBy = "richiestaDiAcquisto", cascade = {CascadeType.ALL})
 private WorkFlowDetail workFlowDetail;
 .....
}

然后我修改了子类：

@Entity()
@Table(schema = "RACQUISTI", name = "WORKFLOW_DETAIL")
public class WorkFlowDetail {
    @GenericGenerator(name = "generator", strategy = "foreign",
        parameters = @org.hibernate.annotations.Parameter(name = "property", value = "richiestaDiAcquisto"))
    @Id
    @GeneratedValue(generator = "generator")
    @Column(name = "ID_RICHIESTA_ACQUISTO", unique = true, nullable = false)
    private int idRichiestaAcquisto;

  @OneToOne(fetch = FetchType.LAZY)
  @PrimaryKeyJoinColumn
  private RichiestaDiAcquisto richiestaDiAcquisto;
  ....
}

在保存主要班级之前(Richiestadiacquisto(，我必须按以下代码将父亲放在子班上：

        richiestaDiAcquisto.getWorkFlowDetail().setRichiestaDiAcquisto(richiestaDiAcquisto);