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 deleted. Is this normal? I cannot delete the same country directly from the database because I get a "foreign key constraint fails" (which is what is supposed to happen).
I am using mySQL/InnoDB database and JBoss 4.0.1 cheers, c View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3877208#3877208 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3877208 ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
