👀 Views: 90 💬 Answers: 1 📅 Created: 2025-06-14

hibernate jpa spring-boot Java

I'm performance testing and I've been researching this but I've looked through the documentation and I'm still confused about I've been banging my head against this for hours... I'm currently working with an scenario with cascading deletes in Hibernate when dealing with a one-to-many relationship between `Parent` and `Child` entities. I have set up the mapping as follows: ```java @Entity public class Parent { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @OneToMany(mappedBy = "parent", cascade = CascadeType.ALL, orphanRemoval = true) private List<Child> children = new ArrayList<>(); // Getters and setters } @Entity public class Child { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @ManyToOne @JoinColumn(name = "parent_id") private Parent parent; // Getters and setters } ``` I expected that when I remove a `Child` from the `children` list in `Parent`, it would be deleted from the database as well. However, when I try to delete a `Parent` entity, I get the following exception: ``` org.hibernate.exception.ConstraintViolationException: could not execute statement ``` I've tried explicitly removing the `Child` entities before calling `entityManager.remove(parent)`, but the same behavior occurs. Here's the code snippet I used to delete a `Parent`: ```java @Transactional public void deleteParent(Long parentId) { Parent parent = entityManager.find(Parent.class, parentId); if (parent != null) { parent.getChildren().forEach(child -> child.setParent(null)); // Attempt to clear parent reference parent.getChildren().clear(); // Attempt to remove children data entityManager.remove(parent); } } ``` Despite my efforts, the `Child` entities are not being deleted as expected and I am still working with the constraint violation. I confirmed that the foreign key relationship is correctly set in the database. I've checked the Hibernate version, which is 5.4.30.Final. Any insights on what might be going wrong or how to properly configure cascading deletes with orphan removal in this scenario would be greatly appreciated! I'm working on a web app that needs to handle this. What's the best practice here? I recently upgraded to Java stable. Thanks for any help you can provide! This is part of a larger desktop app I'm building. Any help would be greatly appreciated!