[JBoss-user] [Persistence CMP/JBoss] - Referential Integrity - CMP - remove()

2005-05-10 Thread christianspiteri
I have 2 CMP beans Candidate and Country. The candidate table has a foreign key country_id with on delete restrict set. However when I delete an entry (using the entity bean remove() method) from the country table, the respective foreign key in candidate is set to null and the country is

[JBoss-user] [Persistence CMP/JBoss] - Referential Integrity

2005-03-09 Thread ebu
Hi. Unfortunately i did not receive any answers to the question about referential integrity i had posted more than week ago (http://www.jboss.org/index.html?module=bbop=viewtopict=60776). The matter is in making it impossible to delete an entity bean instance while it is referenced from

[JBoss-user] [Persistence CMP/JBoss] - Referential Integrity

2005-02-28 Thread ebu
Hi. What is the preferred way to achieve referential integrity without making columns in db annullable? I.e. i wan't to prohibit deletion of an entity if there is even nullable reference to it. I know that ejb spec says that an object should d be removed from all relations before deletion, but