Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 551 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 560 SQLcl
- 4K SQL Developer Data Modeler
- 187.4K SQL & PL/SQL
- 21.4K SQL Developer
- 296.8K Development
- Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.5K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 177 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 164 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 524 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 235 Portuguese
Association is not automatically created between HR schema tables
When using "Business Components From Table" wizard to create entity objects for tables under HR schema, associations & view links are not automatically created even when there is a relationship defined between the tables I am using to create entity objects.
Jdeveloper Version: 11.1.1.9.0
Answers
-
Have you chosen "Business Component from table" to create Eo and vo?
Have you select all table at once?
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,721 Red DiamondYou'll see the creates associations and view links once you click finish.
The summary doesn'T show them.
Timo
-
Thanks for replying to my query Timo. Even after I click on Finish, no association & view link is created automatically.
-
Thanks Manish, please find below my response to your questions.
Have you chosen "Business Component from table" to create Eo and vo?
Yes.
Have you select all table at once?
I have selected 2 tables at once.
-
Make sure foreign key relationship exist between departments and employees table.
I have create using hr schema and jdev 11.1.1.9.0. And following is the output.
-
Yes, the relationship is existing between the tables. I even created 2 custom tables with the relationship but for them too, the association was not created automatically.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,721 Red Diamond
It looks like your installation is corrupt. So far you are the only one with this problem
Can you close JDev, rename the system11.1.1.9.xx.x.xx folder (see https://tompeez.wordpress.com/2011/08/13/how-to-find-and-reset-the-system11-x-x-x-folder-for-a-jdeveloper-installation/ ) and start JDev again. This will be like you have started JDev for the first time. If you are asked to migrate from an earlier version answer 'no'!. Then try to create the business components from tables again.
Timo