Eclipse Community Forums: EclipseLink » Is here the way to regulate result of query to child tables of an entity.

Help

Home

Home » Eclipse Projects » EclipseLink » Is here the way to regulate result of query to child tables of an entity.

Show: Today's Messages :: Show Polls :: Message Navigator

Is here the way to regulate result of query to child tables of an entity. [message #1011860]

Wed, 20 February 2013 11:43

Super User

Messages: 9
Registered: January 2013

Junior Member

Greetings!

Is here way to regulate the fact is query returning data from the child tables of actual entity?

For example, if here one entity relates to another with one to many relationship, could developer to query database for first entity instances only without instances of second one?

Thank you,

[Updated on: Fri, 01 March 2013 12:55]

Report message to a moderator

Re: Is here the way to regulate result of query to child tables of an entity. [message #1014845 is a reply to message #1011860]

Tue, 26 February 2013 15:17

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

If you make the relationship LAZY, it will not be fetch until it is accessed.

EclipseLink also supports fetch groups to load partial objects.

In JPQL you can also select specific fields instead of the entire object.

James : Wiki : Book : Blog : Twitter

Report message to a moderator