Hibernate translates JPA QL
delete from C c where c.b.a.id = :val
to SQL statement
{{DELETE FROM C CROSS[*] JOIN B B1_ WHERE A_ID=? }}

H2 does not understand the generated SQL. Fails with
{{Syntax error in SQL statement "DELETE FROM C CROSS[*] JOIN B B1_ WHERE A_ID=? "; SQL statement:
delete from C cross join B b1_ where a_id=? [42000-197]}}

Please see test in attached project. mvp-h2-wrong-sql.zip