Why OVD Does Not Display Any Or All Entries When A Join Condition On Database Adapter Is Not Satisfied / Existing On A Table?
Last updated on MARCH 08, 2017
Applies to:Oracle Virtual Directory - Version 10.1.4.3 and later
Information in this document applies to any platform.
Oracle Virtual Directory (OVD) 10.1.4.3 and up.
Using Database (DB) adapters to Oracle databases.
DB adapter is configured as follows, for example:
Table 1: MYDEPARTMENT.INDIVIDUAL
Field 1: MY_ID
Table 2: MYDEPARTMENT.MEMBERSHIP
Field 2: MY_ID
The join condition of the DB adapter is on MY_ID.
Searching against the above adapter's namespace does not return all entries, it returns only some of the entries.
Except for the entries that are not returned, all other rows in the Individual table are present in at least one of the rows/entries in the Membership table.
So the adapter is only returning the records where all the fields exists on both tables. If the join condition is not satisfied / existing on one table, then nothing is returned for those entries.
How to configure the DB adapter to return all entries?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms