Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 356611

Summary: Batch reading not available on VariableOneToOneMapping or VariableOneToManyMapping
Product: z_Archived Reporter: Sean Stephenson <sean.r.stephenson>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: P3    
Version: unspecified   
Target Milestone: ---   
Hardware: Macintosh   
OS: Mac OS X - Carbon (unsup.)   
Whiteboard:

Description Sean Stephenson CLA 2011-09-02 10:57:17 EDT 
Build Identifier: EclipseLink 2.3.0

We are trying to remove N+1 selects in many areas of our application and we are having a hard time with our variable mappings, since they don't support batch reading.  It seems like it should be possible to support this feature by doing multiple queries, one per variable class that can be joined.

When using BatchFetchType.IN, it may be possible to do this with fewer queries if fewer values are present in the type field for the actual result rows.

Reproducible: Always

Steps to Reproduce:
1. Create a class with a variable mapping
2. Try to query that class with a batch read on the variable mapping
3. Batch reading is currently not supported on these mappings

This would really help us out and I'm sure anyone else who is using variable mappings as well.  Thanks!
Comment 1 Eclipse Webmaster CLA 2022-06-09 10:20:02 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink