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. 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 ([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 > > > > > > > _______________________________________________ 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]
