My Oracle Support Banner

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 JUNE 12, 2024

Applies to:

Oracle Virtual Directory - Version to [Release 10gR3 to 11g]
Information in this document applies to any platform.


Oracle Virtual Directory (OVD) and up.

Using Database (DB) adapters to Oracle databases.

DB adapter is configured as follows, for example:

Field 1:  MY_ID

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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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