Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Left outer join on a unidirectional many to one mapping
Left outer join on a unidirectional many to one mapping [message #518116] Wed, 03 March 2010 02:08 Go to next message
Andreas Christoforides is currently offline Andreas Christoforides
Messages: 6
Registered: July 2009
Junior Member
I have a many to one relationship from object A to object B.

When I use a bidirectional mapping I can executed the following JPQL query:

SELECT b, a FROM B b LEFT OUTER JOIN b.a a


How can I achieve the same result if I have a unidirectional mapping?

I know it can be done in SQL but I would like to implement it in JPQL.

Thanks,
Andreas

Report message to a moderator

Re: Left outer join on a unidirectional many to one mapping [message #518587 is a reply to message #518116] Thu, 04 March 2010 09:56 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
Senior Member
Maybe,

"Select b, a from A a left join a.b b"

or,
"Select b, a from B b, A a where a.b = b"

James : Wiki : Book : Blog

Report message to a moderator

Re: Left outer join on a unidirectional many to one mapping [message #519188 is a reply to message #518587] Sun, 07 March 2010 16:07 Go to previous messageGo to next message
Andreas Christoforides is currently offline Andreas Christoforides
Messages: 6
Registered: July 2009
Junior Member
The first query is the opposite of what I want. It will give all rows of A and information from B if the relationship is set.

The second query does the same thing but with a different notation.

Would it help if I posted my actual mappings and query?

Report message to a moderator

Re: Left outer join on a unidirectional many to one mapping [message #519191 is a reply to message #518116] Sun, 07 March 2010 16:52 Go to previous messageGo to next message
Andreas Christoforides is currently offline Andreas Christoforides
Messages: 6
Registered: July 2009
Junior Member
Here is the outer join I want to perform in native SQL:

SELECT a.*, b* FROM A a LEFT OUTER JOIN B b ON (b.aID = a.ID);

Report message to a moderator

Re: Left outer join on a unidirectional many to one mapping [message #519383 is a reply to message #518116] Mon, 08 March 2010 11:52 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
Senior Member
That is what,

"Select b, a from A a left join a.b b"

would generate? I assume you want "B b LEFT OUTER JOIN A a" though.

I guess there is no way to do this in JPA without adding the bidirectional relationship, or using native SQL.

In EclipseLink, you can add a OneToOneQueryKey that allows you to define a relationship without having a mapping for it. You can then use the query key in EclipseLink Expression queries. Unfortunately, query keys are not currently supported in JPQL queries (please log a bug for this and vote for it).

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:Database Locks after upgrading from Toplink to Eclipselink
Next Topic:JPA 2 metamodel generator with Maven
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 16:59:00 EDT 2013

Powered by FUDForum. Page generated in 0.07386 seconds