RE: [eclipselink-users] Why is getResultList() grouped by Class even whe

[James Sutherland <jamesssss@xxxxxxxxx>]

I think this hint was only added in the 1.1 stream.  You can either upgrade
to a 1.1 build, or set the property directly on the query.

((ObjectLevelReadQuery)((JpaQuery)query).getDatabaseQuery()).setShouldOuterJoinSubclasses(true);
((ObjectLevelReadQuery)((JpaQuery)query).getDatabaseQuery()).setIsPrepared(false);


t3_chris wrote:
> 
> Hi Christopher
> 
> Christopher Delahunt wrote:
>> 
>> or as a query
>> hint through the eclipselink.inheritance.outer-join hint.
> 
> I've just played around with the query hint, but didn't get any better
> results than without...
> 
> For the Query:
> Query q = em.createQuery("SELECT v FROM VendingmachineComponent v ORDER BY
> v.inventoryId DESC");
> 
> I've tried the following variants:
> 
> q.setHint("eclipselink.inheritance.outer-join", true);
> q.setHint("eclipselink.inheritance.outer-join", "true");
> q.setHint("eclipselink.inheritance.outer-join", "TRUE");
> q.setHint("eclipselink.inheritance.outer-join", 1);
> 
> None of them worked (EclipseLink 1.0.2).
> 
> best regards,
>   christian
> 


-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Why-is-getResultList%28%29-grouped-by-Class-even-when-ORDER-BY-is-used--tp20937838p21032842.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.