Gracias. Werner
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 22. Februar 2006 16:30 > To: [email protected] > Subject: RE: [castor-user] problem deleting dependant objects > > > All right, I am on it > > 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 11:06 > > > Por favor, responda > > > a user > > > > > > > > > > > > > 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] > ------------------------------------------------- > > > > > > > > ------------------------------------------------- > 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] -------------------------------------------------
