> see what entity.primaryKeyRootName() returns for each of the entities > involved ... > > actually on your abstract entity, did you set an external name? make sure you > set that -- external name on the root entity is what is used in 5.4.3 to > determine what sequence to generate.
I was about to try this, but actually, where did you set the "external" name in Entity Modeler?? I just have a "name" field:( Xavier > > ms > > On Feb 2, 2011, at 3:42 PM, Chuck Hill wrote: > >> >> 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 (Webobjects-dev@lists.apple.com) >>>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40anazys.com >>>>>>>> >>>>>>>> This email sent to webobje...@anazys.com >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Do not post admin requests to the list. They will be ignored. >>>>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>>>> >>>>>>> This email sent to ch...@global-village.net >>>>>> >>>>>> -- >>>>>> 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 (Webobjects-dev@lists.apple.com) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >>>>> >>>>> This email sent to msch...@pobox.com >>>> >>>> >>> >> >> -- >> 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com