Eclipse Community Forums: EclipseLink » Problems to use order by a null association

Home » Eclipse Projects » EclipseLink » Problems to use order by a null association(Jpql doesn't return the entities with nulls)

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

Problems to use order by a null association [message #610099]

Tue, 21 September 2010 16:56

No real name
Messages: 7
Registered: April 2010

Junior Member

Hello all!

I have two entities, A and B. A has manyToOne association with B. To list all A's ordered by B's in native sql I use this:

select * from A order by fk_idB

* fk_idB is the foreign key

But in jpql I use:

select a from A a order by a.b.idB

But now only the A's that has a B entity are returned. I need to return all A's! How I can do this?

Please someone help me!
Thanks

Report message to a moderator

Re: Problems to use order by a null association [message #628629 is a reply to message #610099]

Thu, 23 September 2010 09:38

Chris Delahunt
Messages: 995
Registered: July 2009

Senior Member

Hello,

The JPQL "select a from A order by a.b" might work as I believe EclipseLink has optimizations in place to just use the foriegn key. But the spec implies that using a '.' for a relationship should cause an inner join. So to be sure an outer join is used (for instance, if A doesn't have the foreign key), you may want to specify an outer join be used. For example:
"select a from A a outer join a.b b order by b"

Best Regards,
Chris

Report message to a moderator

Previous Topic:	How can I associate primary and secondary tables with a join criteria other than the compound key
Next Topic:	Chain of eager relationships

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 21 00:38:16 EDT 2014