Tuesday, June 11, 2013

Use Non Schema User for ADF Business Components

ADF Model project is configured with Database Connection to generate Business Components from Tables and/or Views. Generated objects are Not Qualified with Schema name if you use Schema User for Connection Configuration. This can cause failures like "Table or View does not exist.", when application executes with a Different User. You can always resolve such errors by creating Synonyms. 

You have two options:
  1. Use Non Schema User for JDeveloper Connection Configuration & no additional work needed when Sharing Code with other Applications.
  2. Use Schema User for JDeveloper Connection Configuration. You will have to create Public Synonyms.
I recommend Option #1 as it is very simple and use of Option #2 can lead to confusion due to use of Synonyms. And this only applies to Code Generation, if you write SQL, you should implement similar option. 

Option 1 : Using Non Schema User for Database Connection



Option 2 : Using Schema User for Database Connection