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 laterInformation 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 |