Re: Horizontal inheritance mismatch between WebObjects 5.4 and 5.3 [ was: SQL generation doesn't conform to entity inheritance]
Re: Horizontal inheritance mismatch between WebObjects 5.4 and 5.3 [ was: SQL generation doesn't conform to entity inheritance]
- Subject: Re: Horizontal inheritance mismatch between WebObjects 5.4 and 5.3 [ was: SQL generation doesn't conform to entity inheritance]
- From: Chuck Hill <email@hidden>
- Date: Tue, 1 Feb 2011 11:24:18 -0800
Hi Xavier,
On Feb 1, 2011, at 12:42 AM, Dev WO wrote:
> I'm still trying to figure out what's happening...
> What I have found so far is that:
>
> If I'm doing:
> -latest 5.4 wonder frameworks except JavaERJDBCAdaptor.framework and PostgresqlPlugIn.framework from 5.3
> -binding to WebObjects 5.4 (using wo.system.frameworks=/System/Library/Frameworks/WebObjects54 in my wolips.properties)
> => SQL generation doesn't conform to entity inheritance
>
> If I'm doing:
> -latest 5.4 wonder frameworks
> -binding to WebObjects 5.4 (using wo.system.frameworks=/System/Library/Frameworks/WebObjects54 in my wolips.properties)
> => SQL generation doesn't conform to entity inheritance
Try it without JavaERJDBCAdaptor.framework at all (just use JavaJDBCAdaptor.framework)
> if I'm doing:
> -lastest 5.3 wonder frameworks
> -binding to WebObjects 5.3 (using wo.system.frameworks=/System/Library/Frameworks/WebObjects53 in my wolips.properties)
> => I've got the correct behavior which is inheritance enforced when generating the SQL in EntityModeler.
>
> So I can say there is something different regarding horizontal inheritance between WebObjects 5.3 and WebObjects 5.4. Based on the first case scenario, it seems the difference occurs within WebObjects frameworks (but maybe something else is involved in the Wonder frameworks in addition to the 2 I keept from 5.3 in the first case).
>
> I don't know if this is to be considered a bug or if there's just something I should add/edit to make horizontal inheritance works under a complete 5.4 setup, but the fact that I couldn't find the same issue on the list makes me feel like the issue could at least be fixed on my side.
It might be that few people are using Horizontal Inheritance. I have not noticed any problem with Single Table Inheritance.
> Any pointer about where to look at to ensure proper horizontal inheritance SQL generation under 5.4?
Based on your evidence, I'd search for "primary" in ERExtensions. If nothing else, that will at least show you were in EOF the PK generation happens.
Chuck
> On 31 janv. 2011, at 18:57, Dev WO wrote:
>
>> Hello,
>>
>> I don't really know where the issue come from, but here's what's happening and what I've already tried to fix it (without a solution so far).
>>
>> I'm using Eclipse 3.6.1.M20100909 cocoa 64
>> WOLips 3.6.6215
>> PostgreSQL 8.4
>> WO 5.4.3
>>
>> My previous setup was WO 5.3.3 with the previous major version of Eclipse (Carbon) and WOLips. The following behavior wasn't happening in this setup.
>>
>> I've got an Abstract entity A and a couple sub-entities, let's say SubA1 and SubA2.
>> In the previous setup, when I generated the SQL for them, they were both correctly referring to A_seq for their primary key generation (in EntityModeler when generating SQL and while the app was running).
>> Now they are referring to SubA1_seq and SubA2_seq (in EntityModeler and while the app is running) which breaks the entire application by providing pk that might be already taken by the other sub-entity...
>>
>> I first thought it could come from the PosgreSQL plugin framework, but after putting back my previous one, the issue is still there (cleaned the project after "updating" the framework).
>>
>> I'll will update WOLips right away to check if it changes anything, but if anyone has an idea on what might cause this issue and even better how to fix it to respect entity inheritance, that would be really nice:)
>>
>> Thanks,
>>
>> Xavier
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden