Myujth

I am working with the following parent-child-relationship:

@Entity
@Audited
public class Parent implements Serializable 
 @Id
 private Long id;

 @OneToMany(mappedBy = "parent", cascade = CascadeType.ALL, orphanRemoval = true)
 private Set<Child> children;

 // Empty default constructor
 // Getters and setters


@Entity
@Audited
public class Child implements Serializable 
 @Id
 private Long id;

 @ManyToOne
 @JoinColumn(nullable = false)
 private Parent parent;

 // Empty default constructor
 // Getters and setters

The use-case I am working on foresees that I am removing a child from its parent, but at this point in time, I am explicitly not supposed to merge the parent entity. Hence, I tried as follows:

Child childFromDb = entityManager.find(Child.class, child.getId());
childFromDb.setParent(null);
entityManager.remove();

This results in an java.sql.BatchUpdateException: (conn:1) Column 'parent_id' cannot be null thrown by Hibernate.

Setting @JoinColumn(nullable = true) resolves this issue but the database schema uses DEFAULT NULL on the column which is not desired as no child objects may exist without a related parent. As a plus, I cannot use a delete statement in HQL, JPQL, native SQL or a CriteriaDelete as the tables are audited using Envers (5.1.4). I remember that Envers does not support bulk statements (insert, update, delete, https://hibernate.atlassian.net/browse/HHH-3554) or CriteraUpdate/CriteraDelete (https://hibernate.atlassian.net/browse/HHH-10318).

How can I remove just the child without merging the parent, keeping the NOT NULL column constraint and not using a different deletion option? Is this even possible?