title: ORA-02292: integrity constraint (xxx) violated - child record found
body: <p>How do i delete all the entries using hibernate deleteAll() ?</p>
  
  <p>I have a class with multiple @oneToMany relationships (having like +5000 child entities) and when i try to do deleteAll i get the title error</p>
  
  <pre><code>oracle.jdbc.OracleDatabaseException: ORA-02292: integrity constraint (xxx) violated - child record found
  </code></pre>
  
  <p>I've tried adding </p>
  
  <pre><code>cascade = {CascadeType.ALL}
  </code></pre>
  
  <p>and</p>
  
  <pre><code>orphanRemoval=true
  </code></pre>
  
  <p>to @OneToMany relationship class, but no help.</p>
  
  <p>It's a bidirectional relationship with following classes</p>
  
  <pre><code>@OneToMany(targetEntity = XXX.class, fetch = FetchType.LAZY, cascade = {CascadeType.ALL}, orphanRemoval=true, mappedBy = "zzz")
      @Fetch(FetchMode.SELECT)
      @JsonManagedReference
      private List&lt;XXX&gt; xxx;
  
  @LazyCollection(LazyCollectionOption.FALSE)
  @OneToMany(targetEntity = YYY.class, fetch = FetchType.LAZY, orphanRemoval=true, cascade = {CascadeType.ALL}, mappedBy = "zzz")
  @Fetch(FetchMode.SELECT)
  @JsonManagedReference
  private List&lt;YYY&gt; yyy;
  </code></pre>
  
  <p>with child elements like</p>
  
  <pre><code>@ManyToOne(fetch = FetchType.LAZY, cascade = {CascadeType.ALL})
  @JoinColumn(name = "XXX", nullable=false)
  @JsonBackReference
  private XXX zzz;
  </code></pre>
  
  <p>i also tried HQL DELETE query but that dosent get me anywhere either.</p>
  
  <p>How on earth do i delete all these entities consistently?
  So far i've manually droped the tables since this problem started (all entities were deleted fine just few days ago) but thats starting to really annoy me, but i cant figure how to do this.</p>
  
  <p>Thanks!</p>