违反完整性约束-未找到父密钥-OneToOne和ManyToOne

Question

将实体插入数据库时遇到问题。我正在使用HibernateJPA。

我有表提醒和提醒行动和每个提醒将保持当前状态的提醒行动（即。OneToOne）和交易结束每个提醒将有许多提醒操作（具有不同的状态）。

DB Table columns are

REMINDER --> REMINDER_ID (PK), CURRENT_ACTION_ID (FK)...
REMINDER_ACTION --> REMINDER_ACTION_ID (PK), REMINDER_ID (FK)...


Reminder Entity
---------------------

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "REMINDER_SEQ_STORE")
@Column(name = "REMINDER_ID", unique = true, nullable = false, precision = 22, scale = 0)
public Integer getReminderId() {
return reminderId;
}



@OneToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL, targetEntity = ReminderAction.class)
@JoinColumn(name = "CURRENT_ACTION_ID")
public ReminderAction getCurrentAction() {
return currentAction;
}


ReminderAction Entity
---------------------

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="REMINDER_ACTION_SEQ_STORE")
@Column(name = "REMINDER_ACTION_ID", unique = true, nullable = false)
public Integer getReminderActionId() {
return reminderActionId;
}


@ManyToOne(cascade=CascadeType.ALL,targetEntity=Reminder.class)
@JoinColumn(name="REMINDER_ID")
public Reminder getReminder() {
return reminder;
}


DAO
---

public void saveOrUpdate(final E transientObject) {
getCurrentSession().saveOrUpdate(transientObject);
getCurrentSession().flush();
}

在saveOrUpdate期间，hibernate从DB获取提醒和提醒操作的顺序

Hibernate: select REMINDER_SEQ.nextval from dual
Hibernate: select REMINDER_ACTION_SEQ.nextval from dual

但是在flush（）期间，Hibernate尝试首先插入ReminderAction，并且由于ReminderAction中的ReminderID无效，因此抛出ORA-02291：违反了完整性约束（REMINDER_ACTION_FK）-未找到父密钥

下面引用线程和问题，因为在DB中触发。但是我没有任何触发提醒和Reminder_ActionDB表。

>

提交事务时违反了完整性约束

Hibernate：插入问题-未找到父密钥

如何让hibernate先插入提醒，然后再插入提醒动作？

更新：

我试图从提醒和提醒行动中删除序列发生器，并在保存或更新期间手动设置ID，最终以相同的异常结束

Reminder rem = (Reminder)transientObject;
rem.getCurrentAction().setReminderId(5);
rem.getCurrentAction().setReminderActionId(5);
rem.setReminderId(5);

getCurrentSession().saveOrUpdate(transientObject);
getCurrentSession().flush();



Hibernate: insert into REMINDER_ACTION (REMINDER_ID, REMINDER_ACTION_ID) values (?, ?)
binding parameter [1] as [INTEGER] - 5
binding parameter [2] as [INTEGER] - 5
SQL Error: 2291, SQLState: 23000
ORA-02291: integrity constraint (REMINDER_ACTION_FK) violated - parent key not found

非常感谢您的帮助。谢谢

Answer 1

我把你的答案从问题中拉出来，并把它放在一个专门的答案中：

将ReminderAction中的ReminderAction设置为nullable=true，并将ReminderAction中的ReminderAction设置为nullable=false

Reminder Entity
---------------

@OneToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL, targetEntity = ReminderAction.class)
@JoinColumn(name = "CURRENT_ACTION_ID", nullable=true)
public ReminderAction getCurrentAction() {
return currentAction;
}

ReminderAction Entity
---------------------
@ManyToOne(cascade=CascadeType.ALL,targetEntity=Reminder.class)
@JoinColumn(name="REMINDER_ID", nullable=false)
public Reminder getReminder() {
return reminder;
}

执行此Hibernate操作将首先插入提醒，然后插入提醒动作。谢谢