hi, i have a problem im running jboss3.2.2RC3 and mysql 4.1.1
i have 2 entitybeans in a realtion 1-M, the design in the database contain a "ON DELETE RESTRICT" . but where i remove the parent entity, the process to remove is: -set to null in the foreign key in the child -delete the childs and the database not throw a exception, because first put null in the child, and after delete the parent. i try put a "NOT NULL" in the reference field in the child, and put <insert-before-postcreate>. this does not work. but i have others entity beans and other relations "ON DELETE CASCADE", it work well. really the relation is most complicated(big father-father-son), the relation in "big father-father" is "on delete cascade" and the relation in "father-son" is "on delete restrict". thanks, and excuse me, i dont speak english. <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824799#3824799";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824799>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
