Raul, I just wanted you to attach a working sample I could use to analyse your problem, iow everything needed to replay your scenario: entities, mapping files, SQL script, etc. Now, if you attached all this as a unified patch (as explained at http://castor.org/how-to-submit-a-bug.html) relatively to src/bugs, this would be of great help to me.
Werner > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 22. Februar 2006 10:56 > To: [email protected] > Subject: RE: [castor-user] problem deleting dependant objects > > > Hi, > > I have created the issue at jira: CASTOR-1330. But I don't > know what you mean by "bug report". > > CEIN, S.A. > > Raúl Sanz de Acedo Pérez > > Técnico Sénior - Dpto. Innovación > Empresarial > > [EMAIL PROTECTED] > > Polígono Mocholí - Plaza Cein, > 31110 Noáin > > > > > > > > > > "Werner Guttmann" > > > <[EMAIL PROTECTED] Para: > <[email protected]> > > in.com> cc: > > > Asunto: RE: > [castor-user] problem deleting dependant objects > > 22/02/2006 10:43 > > > Por favor, responda > > > a user > > > > > > > > > > > > > Raul, > > Can I please (again) ask you to open a Jira issue at > http://jira.codehaus.org/browse/CASTOR, and attach a bug > report (if possible). I'll make sure this wil be taken care > of in due time ... > > Regards > Werner > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Mittwoch, 22. Februar 2006 10:30 > > To: [email protected] > > Subject: [castor-user] problem deleting dependant objects > > > > Helo, > > > > We have found another problem with castor 1.0M2 that did > not occur in > > previous versions (at least in 0.9.5). Let me explain an example: > > > > Imagine we have two tables in a database such as those that follow: > > > > CREATE TABLE TABLEPARENT ( > > IdParent NUMBER(38) NOT NULL); > > > > ALTER TABLE TABLEPARENT ADD ( > > CONSTRAINT PK_TABLEPARENT PRIMARY KEY (IdParent); > > > > CREATE TABLE TABLECHILD ( > > IdChild NUMBER(38) NOT NULL, > > IdParent NUMBER(38) NOT NULL); > > > > ALTER TABLE TABLECHILD ADD ( > > CONSTRAINT PK_TABLECHILD PRIMARY KEY (IdChild); > > > > ALTER TABLE TABLECHILD ADD ( > > CONSTRAINT FK_TABLECHILD FOREIGN KEY (IdParent ) REFERENCES > > TABLEPARENT (IdParent)); > > > > Where the records from "TABLECHILD" as shown above depend > on the table > > "TABLEPARENT" by the primary key of the parent "IdParent". > > > > These are translated into two models where "ChildModel" and > > "ParentModel" > > are related by a member variable of "ChildModel", let's call it > > "IdParent". > > Therefore, "ParentModel" do not have any references of its > child. The > > child know who is its father by its member variable, "IdParent". > > > > Imagine, now, that we want to delete a record "oParentModel" > > from "TABLEPARENT", we must, first, delete its child from > > "TABLECHILD". Let's say this parent only has one children, > > "oChildModel". > > > > Therefore, in the code, we do something like this (in the order > > shown): > > > > JDOManager.getDatabase().remove(oChildModel); > > JDOManager.getDatabase().remove(oParentModel); > > > > So first, castor is told to remove the child record and > afterwards the > > parent one. If not, the database would throw a "child record found" > > and will not allow us to delete the two models. > > > > The problem is that castor does not seem to delete the > models in the > > order we tell it to do it. It seems, castor deletes them in > a random > > order because sometimes it throws a SQLException and the > next try not. > > > > Thanks in advanced, > > > > P.S.: Sorry, this time I have not spent time checking the code so I > > can tell you exactly what it is happening, I could not find time. > > > > CEIN, S.A. > > > > Raúl Sanz de Acedo Pérez > > > > Técnico Sénior - Dpto. Innovación > > Empresarial > > > > [EMAIL PROTECTED] > > > > Polígono Mocholí - Plaza Cein, > > 31110 Noáin > > > > > > > > > > > > > > > > ------------------------------------------------- > > If you wish to unsubscribe from this list, please send an empty > > message to the following address: > > > > [EMAIL PROTECTED] > > ------------------------------------------------- > > > > > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please send an > empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > > > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please send an > empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
