Kodo 4.2 - JDO - Not Handling Bi-Direcitonal Relationships Efficiently. (Doc ID 1089968.1)

Last updated on AUGUST 04, 2022

Applies to:

Symptoms

Given the following scenario using Kodo 4.2 JDO:
- Parent object has a one-to-many relationship to Child objects.
- Child has a field that is a reference back to the Parent (so a bi-directional relationship).
- The Child mapping of the field that references back to the Parent uses the default-fetch-group attribute

When setting a fetch plan programmatically that includes retrieving fields on Parent object (including the field that contains a collection of Child objects) plus Child's field that is a reference back to Parent, it was found that the SQL generated was very inefficient.  First a query looks up the fields for the Parent.  Next, there is a query for each Child element to look up its parent, even though the parents were looked up in the first query.

Changes

None.

Cause

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