tag:blogger.com,1999:blog-5874979429188093780.post3739720151284220741..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Inheritance Feature in Oracle ADF BC - Part 1Andrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-5874979429188093780.post-19284268727842741892013-09-26T23:26:05.588+02:002013-09-26T23:26:05.588+02:00Thanks for the feedback Andrejus. I think this wou...Thanks for the feedback Andrejus. I think this would then just push all the logic back into the database. <br /><br />If I did do this, I might be able to just do a SP call to do the DML operations using dynamic SQL. I don't normally like dynamic SQL, but this would just be for some admin tables.<br /><br />I'll tinker and get back to you later.BradWhttps://www.blogger.com/profile/16750044668400024875noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-69281407747078082832013-09-25T22:23:21.898+02:002013-09-25T22:23:21.898+02:00Hi,
I think you can use it for subtypes coming fr...Hi,<br /><br />I think you can use it for subtypes coming from the same physical DB table only. May be you could create DB view, joining multiple tables and then use ADF inheritance with discriminator for that DB view.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-63155839997056382952013-09-25T17:16:21.545+02:002013-09-25T17:16:21.545+02:00Hi Andrejus.
I have been tinkering with this toda...Hi Andrejus.<br /><br />I have been tinkering with this today and was wondering whether we could have different tables on the subtype? I've tried doing this with the entities and they seem to work fine. However, as soon as I try to create a view object on top of the entity with a different table, jdeveloper complains.<br /><br />My use case is for code tables with the same definition. I'd rather not have to recreate all the same business rules etc for all of the code table entities as there are a lot of them.<br /><br />I'm wondering if it is just a jdeveloper limitation or an actual runtime limitation.<br /><br />Any thoughts on the topic?<br /><br />Thanks,<br /><br /><br />BradWBradWhttps://www.blogger.com/profile/16750044668400024875noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-57872340646912500482013-08-22T02:06:16.666+02:002013-08-22T02:06:16.666+02:00Hi Andrejus,
This blog is very helpful. We have a...Hi Andrejus,<br /><br />This blog is very helpful. We have a scenario where we do not have control over the base Entity Object code. For eg, a ProductEO (on which we dont have control of) consumed in our VO SupportProductsVO. Now, we would like to implement a specific validation method for entity records created specifically for ProductEO. Is there a way we can extend ProductEO as SupportProductEO and code this validation on SupportProductEO and further use this extended EO in the SupportProductsVO. Note, we can not introduce a descriminator value in ProductEO.Aravhttps://www.blogger.com/profile/16633728577707644657noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-34404443580600447112011-03-04T16:16:31.912+01:002011-03-04T16:16:31.912+01:00I would not say its limitation, its just very clea...I would not say its limitation, its just very clear design - 1 EO = 1 DB Entity :)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-20051787921638779532011-03-04T16:07:10.509+01:002011-03-04T16:07:10.509+01:00In fact we’ve already done that. But I’d like to b...In fact we’ve already done that. But I’d like to be sure this is a EO limitation and not just mine.<br /><br />Thanks for spending your time.Unknownhttps://www.blogger.com/profile/03246949146426501602noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-58095277660184568112011-03-04T15:53:26.828+01:002011-03-04T15:53:26.828+01:00May be you can join these tables using database Vi...May be you can join these tables using database View, only that it will be not updatable.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-65348189996235993382011-03-04T15:36:05.538+01:002011-03-04T15:36:05.538+01:00After reading you excellent article and the ADF gu...After reading you excellent article and the ADF guide, still have no solution for my inheritance problem.<br />Your solution and the guide’s are both based on having a single table containing all attributes. No problem with that at all. But “my”schema implements one table with attributes common to all types, and a table for each subtype.<br />In JPA 2 there is a solution for this scenario, but couldn’t find one using ADF Entity Objects.<br />I’m from Brasil and not so good in English, so maybe I’m not very clear in my explanation.<br /><br />Thanks in advance.Unknownhttps://www.blogger.com/profile/03246949146426501602noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-925721669991139932010-07-30T00:04:44.841+02:002010-07-30T00:04:44.841+02:00Hi Andrejus,
I have create a polymorphic View Hier...Hi Andrejus,<br />I have create a polymorphic View Hierarchy EmpVO,ClerkVO,SalesPersonVO based on discriminator colums JOB_TYPE. SalesPerson has additional column Comission. In App Module , I have EmpVO1 and subtypes ClerkVO and SalePersonVO declared.<br />This is as per Steve http://www.oracle.com/technology/oramag/oracle/10-mar/o20frame.html<br />Now when I run the App Module using Business Component Browser and Navigate through EmpVO1, it brings up the screen properly, meaning when SalesPerson record comes commission is displayed.<br />Now my question is how the same display functionality could be achieved on the web pageAbhishek Kumarhttps://www.blogger.com/profile/12535332664370291891noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-64247004372857568782010-02-17T13:59:28.060+01:002010-02-17T13:59:28.060+01:00Hi,
If you want to change inheritance structure o...Hi,<br /><br />If you want to change inheritance structure on runtime, its not possible. In ADF BC inheritance is used mainly during development, in order to design your Model more effectively.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-6505813199627127352010-02-17T13:13:44.341+01:002010-02-17T13:13:44.341+01:00Sorry but I don't understand how can You manag...Sorry but I don't understand how can You manage the situation I described.<br />I don't know "a priori" every subtype and I don't have any discriminatory column.<br />Subtypes are not in different tables but in the same table : it's just a different, customized implementation of the same table.<br />I also don't want keep them in the same project because I want to deploy in different situations (sometimes I want customization and sometime I don't).<br />Can I still use inheritance ?<br />Tkstullio0106noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-27449779177785013472010-02-17T10:07:35.019+01:002010-02-17T10:07:35.019+01:00Yes, its what is described in this blog.Yes, its what is described in this blog.Andrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-26286232285925643792010-02-17T10:03:29.502+01:002010-02-17T10:03:29.502+01:00Too simple.
In real life is not possible to know &...Too simple.<br />In real life is not possible to know "a priori" every implementation and implemetations should be applied in different customizations.<br />The "slave" entity should know it's master but the masted can't know every slave.<br />It should be possible to add columns/relationships in the master entity and "inerhit" them in slaves.<br />Could You apply the solutionin such real situation ?<br />Tkstullio0106noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-16464138714936042922009-08-04T19:07:48.133+02:002009-08-04T19:07:48.133+02:00Hi,
The tables in my application share about 10 ...Hi, <br /><br />The tables in my application share about 10 common columns, I'd like to use inheritance to code some common business logic for these columns and have the tables inherit from this. I've tried using this process but a can't do it without adding an extra column for the discriminator, which I don't want to have to do. Is there a work around that you are aware of?<br /><br />Thanksfakintoyehttps://www.blogger.com/profile/05114220664872415806noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-47211994255094634022009-05-05T06:43:00.000+02:002009-05-05T06:43:00.000+02:00Thanks ;)
AndrejusThanks ;)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-11998916222775568342009-05-05T00:44:00.000+02:002009-05-05T00:44:00.000+02:00Great Article!!
I was trying to experiment with Di...Great Article!!<br />I was trying to experiment with Discriminator myself but this article explains things in a neat way.<br />Thanks for posting this.HusainDhttps://www.blogger.com/profile/08119731737785573060noreply@blogger.com