My Oracle Support Banner

Batch Reading Query On Detail Objects Even Though Last Query On Parent Was Primary Key Based (Doc ID 860343.1)

Last updated on MAY 25, 2021

Applies to:

Oracle TopLink - Version 4.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.


Symptoms

Entity Object Model

"Contract" has OneToManyMapping to "Role"
"Contract" has OneToManyMapping to "ContractMainData" with batch-reading configured.
"Contract" has OneToManyMapping to "ReferenceDocument" with batch-reading configured.

All this relationship mappings are privately-owned and have batch-reading and transparent
indirection configured.

Problem Scenario

The method executing the first query on "Contract" is configured like this

Problem

One could expect that TopLink propagates the last query on the primary class to the detail relationship query, but TopLink propagates the query that had been used to obtain the primary object from the database and put it into the shared cache.

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
 Entity Object Model
 Problem Scenario
 Observed Behavior
 Problem
Cause
Solution


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