On Feb 2, 2011, at 12:36 PM, Dev WO wrote: >> This sounds really familiar ... I think it was a bug in 5.4.3. > > OK, and as I wouldn't hold my breath for 5.4.4 is there a way to fix it:)
It can probably be fixed in Wonder. But first you have to identify where the problem is and what the fix is. :-) Chuck >> On Feb 2, 2011, at 12:46 PM, Dev WO wrote: >> >>> Hello Chuck, >>> >>> With JavaERJDBCAdaptor or the default JavaJDBCAdaptor, the result is the >>> same, it doesn't conform to the inheritance modeled in EntityModeler. >>> I've got to check into ERExtensions if I can find something. >>> >>> I understand not everyone is using Horizontal Inheritance, but I must not >>> be the only one trying to figure out what's going on with 5.4. >>> >>> Just to make sure, I've created a new Wonder framework, created only an >>> abstract entity and 2 sub-entities with horizontal inheritance, and the >>> generated SQL is not correct, it doesn't conform to the modeled inheritance >>> by requesting sequence for the pk for each sub-entity instead of the >>> abstract parent sequence. >>> It looks to me this is a bug, I'm not 100% sure it's in Wonder or >>> Webobjects though. Should I fill a Jira for this? I don't think this could >>> be qualified as a regression as I don't even know if this bug was ever in >>> 5.3. >>> >>> Thanks for your help, >>> >>> Xavier >>> >>> On 1 févr. 2011, at 20:24, Chuck Hill wrote: >>> >>>> 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 protected]) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40anazys.com >>>>>> >>>>>> This email sent to [email protected] >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>> >>>>> This email sent to [email protected] >>>> >>>> -- >>>> 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 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >>> >>> This email sent to [email protected] >> >> > -- 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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
