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]
-------------------------------------------------
