5 Replies Latest reply on Jun 21, 2004 7:20 AM by girazu

    Major CMP bug with relations with JBoss 3.2.2?

    edikus Newbie

      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?