I have set up a many-to-one relation using CMR and Oracle 8i, where the navigation is 
unidirectional from the many side to the one side. In my jboss relation, I set up an 
fk constraint (done via XDoclet). Due to an error in another part of the code, I was 
attempting to delete some of the rows on the one side of the relation without having 
already deleted the foreign keys from the many side. I would have expected an 
integrity constraint violation to be thrown and the transaction to fail. Instead, what 
happened was that the rows on the one side got deleted, and the pointers on the many 
side got set to null! This is contrary to any expectation that a SQL user would have. 
Can anyone explain this, or is this indeed a major bug?

<a 
href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826570#3826570";>View 
the original post</a>

<a 
href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826570>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

Reply via email to