My Oracle Support Banner

KODO 4.2 EAGER FECHING NOT QUERYING EFFICIENTLY WITH ONE-TO-ONE-TO-MANY RELATION (Doc ID 1122843.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Kodo - Version 4.1 and later
Information in this document applies to any platform.

Symptoms

Kodo 4.2 JDO. 
If you have a one-to-one-to-many relationship A(1) --> B(1) --> C(*), for example,  (1)Parent -> (1) Child -->  (*) Friend, when eager fetching this object graph the SQL generated is inefficient.  In the test case eager fetching was defined programmatically. For example:

Changes

None.

Cause

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
Symptoms
Changes
Cause
Solution
References


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