RE : bad sql on n-m relation to subclassed object

[Nicolas DELAHAYE <de...@laposte.net>]

Hi jakob,

I have not left the project because of OJB, of course ;)
I have not succeeded to reproduce the behavior explained below. And, I
think it is a mistake on our code.

Best regards
Nicolas DELAHAYE


-----Message d'origine-----
De : Jakob Braeuchi [mailto:jbraeuchi@gmx.ch] 
Envoyé : vendredi 10 mars 2006 19:09
À : OJB Users List
Objet : Re: bad sql on n-m relation to subclassed object


hi nicolas,

please post the relevant parts of the repository.xml and eventually the 
generated sql.

i hope you didn't leave the project because of ojb ;)

jakob

delahaye.nicolas schrieb:
> Hi jakob,
> 
> Thank for your answer.
> 
> I have see an other strange thing : I have a class B that inherit from

> A and a MN relationship between B and C. When i make a insert, the 
> relation table is filled, but when i update the relation, the relation

> table is not updated !
> 
> Usually, the relation table for MN link is "delete" before new insert 
> that represent the update.
> 
> Why couldn't have the same behavior ?
> 
> 
> Best regards,
> Nicolas DELAHAYE
> PS:
> I have left the project that used OJB, but I have forwarded your email

> to the project manager. If I found time, i shall try to mount a 
> unittest to show the different behavior already explained.
> 
> 
>>hi nicolas,
>>
>>we recently fixed a problem concening findObjectByIdentity see 'OJB 
>>and the X-Files... :)' in this case the sql looked
> 
> ok, but the
> 
>>wrong object was materialized.
>>
>>if the problem still persists, could yu please post a
> 
> testcase so i can
> 
>>try to reproduce it.
>>
>>thanks
>>jakob
>>
>>DELAHAYE Nicolas schrieb:
>>
>>>hi Jakob Braeuchi
>>>
>>>I have this model :
>>>
>>>A link to A
>>>B, C, and D that inherit of A
>>>
>>>when i would like retreive a object A by
> 
> findObjectByIdentity, the left
> 
>>>out join make a link on A.id = A.idreftoA for each
> 
> inherited classes.
> 
>>>idreftoA is define as primary key and foreigner key of
> 
> inherited
> 
>>>classes. but A has not idreftoA field.
>>>
>>>I have tried with no link A to A, but it is the same
> 
> behaviors.
> 
>>>how do i make the mapping for A ?
>>>
>>>best regards
>>>Nicolas DELAHAYE
>>>
>>>Jakob Braeuchi wrote:
>>>
>>>
>>>>hi nicolas,
>>>>
>>>>i'm pleased the latest version works for you.
>>>>could you please post the error, or give me a hint where
> 
> you found
> 
>>>>discussions about the bug.
>>>>
>>>>jakob
>>>>
>>>>delahaye.nicolas schrieb:
>>>>
>>>>
>>>>>Hi jakob,
>>>>>
>>>>>Ok, it is working with 1.0.4. But if i want retreive the
> 
> super class
> 
>>>>>alone, a wrong SLQ
>>>>>query is made, I have seen on the forum that is a bug. My question 
>>>>>is : do you know if this defect will be fixed
> 
> on 1.0.5 ?
> 
>>>>>Best regards
>>>>>Nicolas DELAHAYE
>>>>>
>>>>>
>>>>>
>>>>>>hi nicolas,
>>>>>>
>>>>>>ojb just release 1.0.4. could you please try this as well ?
>>>>>>
>>>>>>jakob
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
> 
> 
> Accédez au courrier électronique de La Poste : www.laposte.net ;
> 3615 LAPOSTENET (0,34 €/mn) ; tél : 08 92 68 13 50 (0,34€/mn)
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

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


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