HQL delete does not honour cascades defined within hibernate mappings.

If deleting by HQL, you need delete children before you can delete the parent. It won't honor the cascade setting in the hibernate mappings.