java - 如何使用无状态 session 从集合中删除元素？ (ConstraintViolationException)

我有

@ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
public Linf getLinf() {
    return linf;
}

和

@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, targetEntity = MessageEntry.class)
public Set<MessageEntry> getMessageEntries() {
    return messageEntries;
}

我需要从数据库中删除单个messageEntry。如果我说sess.delete（messageEntry），那么我会从Linf.messageEntries集合中获取索引异常。无状态会话无法加载集合，所以我有
手动加载Linf.messageEntries的元素，然后删除其中之一：

            List linfs = sess.createQuery(
                    "SELECT l FROM Linf l " +
                            "JOIN l.messageEntries e WHERE e=:e")
                    .setParameter("e", messageEntry).list();

            if (linfs.size()>1) throw new RuntimeException();

            Linf linf = (Linf) linfs.get(0);

            List<MessageEntry> curEntries =
                    sess.createQuery(
                            "SELECT e FROM Linf l " +
                            "JOIN l.messageEntries e WHERE l=:l")
                            .setParameter("l", linf).list();

            for (int i = 0; i < curEntries.size(); i++) {
                if (curEntries.get(i).getId().equals(messageEntry.getId())) {
                    curEntries.remove(i);
                    break;
                }
            }

            Set<MessageEntry> cur = new HashSet<MessageEntry>();
            cur.addAll(curEntries);
            linf.setMessageEntries(cur);

            messageEntry.setLinf(null);
            sess.update(messageEntry);
            sess.update(linf);
            sess.delete(messageEntry);

我收到ConstraintViolationException：无法删除或更新父行：外键约束失败（db。linf_messageentry，CONSTRAINT FK5039A8B5E770809A外国密钥（messageEntries_id）参考messageentry（id））。如何执行此任务？谢谢。

最佳答案

您的映射错误。在MessageEntry中使用外键代替了双向的一对多关联，而使用联接表（linf_messageentry）则具有OneToMany关联，而使用外键则具有另一个独特的ManyToOne关联。

必须使用mappedBy属性将一侧标记为多侧的反面：

// This is the owner side of the association, because it doesn't have
// the mappedBy attribute.
// it uses a join column by default
@ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
public Linf getLinf() {
    return linf;
}

和

// This is the inverse side, because it has the mappedBy attribute
// since it's mappedBy linf, hibernate uses the same mapping as the one
// described on the linf property: a join column
@OneToMany(mappedBy = "linf", fetch = FetchType.LAZY, cascade = CascadeType.ALL)
public Set<MessageEntry> getMessageEntries() {
    return messageEntries;
}

另外，请注意：


targetEntity属性是完全冗余的：Hibernate从集合的类型中知道目标实体：Set<MessageEntry>
在ManyToOne上的层叠= CascadeType.ALL没有多大意义。如果删除MessageEntry，则不希望其Linf被删除。