[hibernate-dev] 6.0 - multi-table mutations

[Steve Ebersole]

On Tue, Mar 26, 2019 at 9:57 AM Sanne Grinovero <sanne at hibernate.org> wrote:

> One question: could we benefit from "cascade delete" rules defined in
> the table structure?


> If Hibernate ORM was able parse the cascading rules from existing
> schemas, and possibly generate them for new schemas, you could have an
> entire crop of additional such optimisations. I'm not sure if I'm
> talking about material for ORM 7+ but if you could make sure that such
> future optimisations aren't ruled out that would be awesome :)
>

Good point.

We actually do already have some limited support for cascading FKs in ORM -
`org.hibernate.annotations.OnDelete`.  And it is exported to the database
if defined.  We do not (nor should we) parse this information from the
existing schema.

What you are asking about specifically would require us to round out that
support (secondary tables at least are not yet supported) and of course to
leverage that in the HQL bulk deletion handlers.  Not impossible or even
particularly difficult - but enough work that I'd rather that be handled
somewhere post-6.0