db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: [BUG?] In order of FK description @ <reference-descriptor>
Date Fri, 19 Dec 2003 22:03:29 GMT
hi antonio,

i would have expected problems (wrong child object loaded) during read 
as well...
but after reading the detailed description of ron i think everything is 
clear now.

jakob

Antonio Gallardo wrote:

> Jakob Braeuchi dijo:
> 
>>hi antonio,
>>
>>i just wanted to know whether you have problems during insert, updater,
>>select or in all of them?
> 
> 
> The problem was showed to me at INSERT.
> 
> Best Regards,
> 
> Antonio Gallardo.
> 
> 
>>jakob
>>
>>Antonio Gallardo wrote:
>>
>>>Jakob Braeuchi dijo:
>>>
>>>
>>>>hi antonio,
>>>>
>>>>do you have an sql ready ?
>>>
>>>
>>>?? Don't understand. I guess if I have a test of this. The posted sample
>>>is a simplication of 2 tables with 30 fields each one that also have
>>>other
>>>relations.
>>>
>>>This bug or feature? got 1 day of my time while trying to understand why
>>>this does not work.
>>>
>>>Finally realized the change explained below is the source fo the
>>>problem.
>>>
>>>
>>>
>>>>jakob
>>>>
>>>>Antonio Gallardo wrote:
>>>>
>>>>
>>>>>Hi:
>>>>>
>>>>>I found the follwing problem. I am not sure if this is a bug or lack of
>>>>>documentation. Anyway, I think we need to see this:
>>>>>
>>>>>I have a 2 fields Primary Key (PK) on a class A defined as follow:
>>>>>
>>>>><class-descriptor class="test.A" table="A">
>>>>> <field-descriptor name="id_1" primarykey="true" default-fetch="true"
>>>>>     column="ID_A" jdbc-type="INTEGER"/>
>>>>> <field-descriptor name="id_2" primarykey="true" default-fetch="true"
>>>>>     column="ID_B" jdbc-type="INTEGER"/>
>>>>> <collection-descriptor name="bList" element-class-ref="test.b"
>>>>>         auto-update="false" auto-delete="false">
>>>>>     <inverse-foreignkey field-ref="id_1"/>
>>>>>     <inverse-foreignkey field-ref="id_2"/>
>>>>> </collection-descriptor>
>>>>></class-descriptor>
>>>>>
>>>>>Please note the order how are defined the PK. First is id_1 then id_2!
>>>>>Now
>>>>>the secodn class:
>>>>>
>>>>><class-descriptor class="test.B" table="B">
>>>>> <field-descriptor name="id" primarykey="true" default-fetch="true"
>>>>>     column="ID_A" jdbc-type="INTEGER"/>
>>>>> <field-descriptor name="id_2" default-fetch="true"
>>>>>     column="ID_B" jdbc-type="INTEGER"/>
>>>>> <field-descriptor name="id_1" default-fetch="true"
>>>>>     column="ID_A" jdbc-type="INTEGER"/>
>>>>> <reference-descriptor name="A" class-ref="test.A"
>>>>>         auto-update="false" auto-delete="false">
>>>>>     <foreignkey field-ref="id_1"/>
>>>>>     <foreignkey field-ref="id_2"/>
>>>>> </reference-descriptor>
>>>>></class-descriptor>
>>>>>
>>>>>Seems like the order of the defined inverse-foreign keys is very
>>>>>important
>>>>>(not documented at all website) since if in the sample we change the
>>>>>"order" of id_1 and id_2 in both above describe <class-descriptor>
just
>>>>>in
>>>>>the <collection descriptor> of class A and the <reference-descriptor>
>>>>>of
>>>>>class B We got an referential integrity error, reference from B not
>>>>>found
>>>>>in A!
>>>>>
>>>>>Note the order of fields in class B, (first id_2, follow id_1) they are
>>>>>intentionally changed as they are in class A.
>>>>>
>>>>>I hope the problem is good explained, if not please let me know. I will
>>>>>try to explain it better.
>>>>>
>>>>>Best Regards,
>>>>>
>>>>>Antonio Gallardo
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>>>For additional commands, e-mail: ojb-dev-help@db.apache.org
>>>
>>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-dev-help@db.apache.org
>>
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message