use entityManger.remove instead of jpa query to enable cascade delete.

Yeah, I guess it will be slow luckily deleting is not something you do a lot, other option would be to use native query