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:
- Use Non Schema User for JDeveloper Connection Configuration & no additional work needed when Sharing Code with other Applications.
- 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
No comments:
Post a Comment