i still would like to see what entity.primaryKeyRootName returns for each ... i don't recall what the impl was in 5.4.3 and I don't have it checked out at the moment, but i'm pretty sure that method is the only thing that matters here.
ms On Feb 2, 2011, at 4:56 PM, Chuck Hill wrote: > > On Feb 2, 2011, at 1:03 PM, Dev WO wrote: > >> OK, I tried this actually (even if I don't like that because it creates >> un-used tables I have to clean;)), > > Some databases (FrontBase) need this table as the sequence is attached to it. > > >> but still got the wrong inheritance. >> >> So maybe not a winner Chuck;) >> But I would have hoped for;) >> >> Another player? same player shoot again? > > With the table name set, what do you see? What do you expect to see? > > > Chuck > > >>> On Feb 2, 2011, at 12:56 PM, Dev WO wrote: >>> >>>> >>>>> 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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>> -- >>> 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 >>> >>> >>> >>> >>> >>> >>> >> > > -- > 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