英文:
Unable to remove childs in OneToMany Mapping and add new childs [Hibernate]
问题
我知道这个问题已经被问过很多次，但是没有一个解决方案适用于我。
所以我有一个父类：
class User{
@Id
@NotNull
@Column(name = "UserId", nullable = false)
private Long userId;
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
@JoinColumn(name = "UserId")
private Set<Phone> phoneList;
}
还有一个子类：
class Phone {
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "UserId")
private User user;
}
现在当我收到一个更新用户类的新手机列表时，我想要删除所有旧的手机并添加新的手机。请注意，所有这些操作都发生在同一个 @Transactional 中。
我尝试过的解决方案：
user.getPhoneList().clear();
user.getPhoneList().addAll(新的手机列表);
当我尝试上述逻辑时，Hibernate 试图将旧的手机的 userId 设置为 null。在这个位置上，我得到一个 DataIntegrityViolation，因为 Phone 表中的 userId 是非空列。
请提供一个适当的解决方案，可以在这里工作。
英文:
I know this question has been asked many times but none of the solution is working for me.
So I have a Parent class :
class User{
@Id
@NotNull
@Column(name = "`UserId`", nullable = false)
private Long userId;
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
@JoinColumn(name = "`UserId`")
private Set<Phone> phoneList;
}
And a child class:
class Phone {
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "`UserId`")
private User user;
}
Now when I received a update for User class with new phone list, I want to remove all the old phones and add new phones. Please note that this all operation is happening in same @Transactional.
Solution I tried:
user.getPhoneList().clear()
user.getPhoneList().addAll(new phone list)
When I try the above logic, Hibernate is trying to set old phone with userId as null. At this position I am getting DataIntegrityViolation as userId in Phone table is non null column.
Please provide any appropriate solution which can work here.
答案1
得分: 0
Hhhmmm... 我有完全相同的逻辑，而且我的代码能正常运行。这是我的类：
@Data
@Entity
public class ProductReference {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@OneToMany(mappedBy = "productReference", fetch = FetchType.EAGER, cascade = CascadeType.REMOVE, orphanRemoval = true)
private Set<Attribute> attributes = new HashSet<>();
}
唯一我看到的区别是 `CascadeType.REMOVE`：
@Data
@Entity
public class Attribute {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@ManyToOne
private ProductReference productReference;
}
我的删除操作：
productReference.getAttributes().clear();
你使用的 Hibernate 版本是多少？我使用的是 `org.hibernate.Version - HHH000412: Hibernate Core {5.4.10.Final}`
英文:
Hhhmmm... I have the exact same logic and it works fine by me. Here are my classes
@Data
@Entity
public class ProductReference {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@OneToMany(mappedBy = "productReference", fetch = FetchType.EAGER, cascade = CascadeType.REMOVE, orphanRemoval = true)
private Set<Attribute> attributes = new HashSet<>();
}
The only difference I see is the CascadeType.REMOVE
@Data
@Entity
public class Attribute {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@ManyToOne
private ProductReference productReference;
}
My deletion:
productReference.getAttributes().clear();
Which Hibernate version you have? by me it is org.hibernate.Version - HHH000412: Hibernate Core {5.4.10.Final}
专注分享java语言的经验与见解，让所有开发者获益！
评论