Why OVD Does Not Display Any Or All Entries When A Join Condition On Database Adapter Is Not Satisfied / Existing On A Table? (Doc ID 1090821.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Goal

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?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.