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 MARCH 08, 2017

Applies to:

Oracle Virtual Directory - Version 10.1.4.3 and later
Information in this document applies to any platform.

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

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