RE: [eclipselink-users] Native queries & batch hint

[James Sutherland <jamesssss@xxxxxxxxx>]

I believe the null-pointer was fixed.  The code is correct on the MAIN
stream.

The bug was,
https://bugs.eclipse.org/bugs/show_bug.cgi?id=296712

You could create the EclipseLink ReadAllQuery directly and use
addJoinedAttribute(), or upgrade to the latest build. (or use JPQL, or
Expressions, or Criteria instead of native SQL)


Swierzynski, Rafal wrote:
> 
> Hi James,
> 
> By "join fetching is supported on native SQL queries", do you mean that I
> have to use a named native query with a hint? Because query.setHint()
> throws NPE for any hint.
> 
> Thanks for your answer.
> 
> Regards,
> Rafał
> 
> -----Original Message-----
> From: eclipselink-users-bounces@xxxxxxxxxxx
> [mailto:eclipselink-users-bounces@xxxxxxxxxxx] On Behalf Of James
> Sutherland
> Sent: Tuesday, January 19, 2010 4:07 PM
> To: eclipselink-users@xxxxxxxxxxx
> Subject: Re: [eclipselink-users] Native queries & batch hint
> 
> 
> Batch reading requires the usage of generated SQL, as we must generate the
> batch query based on the original query.  Native SQL queries are not
> supported, you should get a better error though, please log a bug for the
> null-pointer.
> 
> Join fetching is supported on native SQL queries, provided you give the
> correct SQL that returns the expected data.
> 
> 


-----
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://old.nabble.com/Native-queries---batch-hint-tp27224057p27323889.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.