我有一个一对多的关系,如下
@Entity
@Table(name = "reminderheader")
public class ReminderHeader implements Serializable {
@Id
@org.hibernate.annotations.GenericGenerator(name = "REMINDER_HEADER_GEN", strategy = "native")
@GeneratedValue(generator = "REMINDER_HEADER_GEN")
@Column(name = "id", unique = true, nullable = false)
@Basic(fetch = FetchType.EAGER)
private long id;
@OneToMany(fetch = FetchType.EAGER, orphanRemoval = true)
@Cascade(value = { CascadeType.SAVE_UPDATE, CascadeType.DELETE })
@JoinColumn(name = "HeaderID")
@Fetch(FetchMode.SELECT)
private Set<ReminderDetails> reminderDetailslist;
}
and
@Entity
@Table(name = "reminderdetails")
public class ReminderDetails implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", unique = true, nullable = false)
@Basic(fetch = FetchType.EAGER)
private long id;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "HeaderID", nullable = false)
private ReminderHeader reminderHeader;
}
当我想删除的时候ReminderHeader
从MySQL数据库中获取如下
String query = "delete ReminderHeader rHdr where rHdr.recipientGUID = :rHeaderGUID ";
Query myQry = getCurrentSession().createQuery(query);
myQry.setString("rHeaderGUID", RemHeaderGUID);
int deletedRow = myQry.executeUpdate();
然后我得到以下错误
无法删除或更新父行:外键约束失败
我怎样才能删除ReminderHeader
和它的ReminderDetails
孩子们没有收到这个错误吗?
Update:我将一对多关系更改如下:
@OneToMany(fetch = FetchType.EAGER, orphanRemoval = true, mappedBy = "reminderHeader")
@Cascade(value = { CascadeType.SAVE_UPDATE, CascadeType.DELETE })
@Fetch(FetchMode.SELECT)
private Set<ReminderDetails> reminderDetailslist;
and
@ManyToOne(fetch = FetchType.EAGER)
private ReminderHeader reminderHeader;
我使用以下方法进行删除
String query = "From ReminderHeader rHdr where rHdr.recipientGUID = :rHeaderGUID ";
Query myQry = getCurrentSession().createQuery(query);
myQry.setString("rHeaderGUID", RemHeaderGUID);
List<ReminderHeader> remList = myQry.list();
for (int i = 0; i < remList.size(); i++) {
getCurrentSession().delete(remList.get(i));
}
但它没有改变数据库中的任何内容,也没有出现错误或异常。