I'm having a strange behaviour using cascade-delete statements. A Client has many profiles and each profile can have many users. I add on both relations a cascade-delete statement. But, when I delete a client JBoss correctly prepare things to delete all profiles but ignores the cascade-delete from the profile to user relation. So, when it executes the first Profile delete, a constraint violation is thrown.
His this a normal behaviour?
Thanks in advance.
PS - I also have an extra relation between the a client and a user, and I also try do add a cascade-delete on this relation...but it is also ignored...or executed out of order.