Thursday, September 9, 2010

ADF Model: Creating Entity Association

An Entity Association defines the relationship between two entities or EOs. Follow the below steps to create an entity association.

1. In Model project, right click on any package, select 'New Association'.

2. Now, 'Create Association' wizard appears -> In the 'Name' stop, Give Name for the Association, select/give package for the Association. The Association Name is generally follows the convention <SourceEO>To<DestinationEO>. E.g., DeptEOToEmpEO.

3. Click 'Next' -> In the 'Entity Objects' section, select the Source and Destination EOs and the attributes in Source and Destination EOs on which you want define the association.

4. Click 'Next' -> In the 'Assocation Properties' section, specify the properties if applies. For e.g., if the assocation is composite, check the box 'Composite Association'.

5. Click 'Next' -> In the 'Edit Assocation Query' section, verify if the where clause for the association generated is right. You can modify the query where clause if needed.

6. Click 'Next' -> 'Summary' displays the summary of the created association -> Click 'Finish'.

7. Now, you'll find the newly created Association in model project under the specified package.

8. Once, you create the association between EmpEO and DeptEO, Jdeveloper will add the association accessors in each of the EOs.


  1. Hi,

    Do you know if it's possible to create association between views from 2 different modules .
    Like: demo.model.DemoModel and demo.model.DemoModel1 which contains views from 2 different databases?
    And if it's possible what's the trick to see them at choose time for association.


  2. I've been looking for info on this topic for a while. I'm happy this one is so great. Keep up the excellent work 메이저놀이터

  3. Love to read it, Waiting For More new Update and I Already Read your Recent Post its Great. Thank you for sharing useful Information 먹튀검증

  4. I read this article. I think You put a lot of effort to create this article. I appreciate your work. seo tijuana

  5. 'Have fun' is my message. Be silly. You're allowed to be silly. There's nothing wrong with it. 오피

  6. Health fitness points also propose that vices need to be stopped 슬롯사이트

  7. I am really enjoying the design and layout of your blog.Complete the online application to Turkey from on the Turkish eVisa website and confirm your application and pay e visa Turkey Cost. Within minutes

  8. I have read this article many times, and I found it very helpful. I really appreciate the time and effort you put into this and click here to apply for an urgent visa to India from USA. An e-visa to India has now become easier to obtain.

  9. You make so many great points here that I read your article a couple of times. Hey travelers, now e visa Pakistan is easy to get online. You don’t need to visit the embassy for a Pak visa. Save your time & money by applying online.


Related Posts with Thumbnails