Hi all,
I've come across some interesting CMP/CMR behaviour in JBoss 3.2.6.
To explain, let me define a scenario. Suppose we have two entities, 'Person' and 'PhoneNumber'. We define a CMR relationship between them such that a 'Person' can have relationships with multiple 'PhoneNumber' entities and each 'PhoneNumber' can be associated with multiple 'Person' entities.
PhoneNumber ID Number 1 07713 2 87383 Person Name FullName Bob Robert Mary Mary Person_PhoneNumber PhoneNumber Person 1 Bob 1 Mary 2 Bob
select ID, number from PhoneNumber where ID = 1; ##Find by PK ## Generated as a result of the 'remove' select Person from Person_PhoneNumber where PhoneNumber = 1; select Name, FullName from Person where (Name=Bob) OR (Name=Mary); delete from Person_PhoneNumber where (PhoneNumber=1) AND (Name=Bob OR Name=Mary); delete from PhoneNumber where ID = 1;
select ID, number from PhoneNumber where ID = 1; ## Find by PK ## Generated as a result of the 'remove' delete from Person_PhoneNumber where PhoneNumber = 1; delete from PhoneNumber where ID = 1;