Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Problem with LEFT JOIN and long field
Problem with LEFT JOIN and long field [message #831947] Thu, 29 March 2012 10:59 Go to next message
Tobias L is currently offline Tobias L
Messages: 1
Registered: March 2012
Junior Member
Hi everyone,

we went into a problem during our migration from Glassfish v2 to Glassfish v3. There are two entities (lets call them A and B) with an optional dependency (no matter if @OneToOne or @ManyToOne) between them.

We defined now a query like:
"SELECT b.id, a.id FROM B b LEFT JOIN b.refToA a"

For not defined references we get the value 0 for the second id. We expected null and got this values already with Glassfish v2. Do we use it in the wrong way or is this a bug in EclipseLink?

You can find a failing example of this problem on github.com in the user profile "bitsunited" and the project is called "leftjointest".

Thanks for your help! Smile
Re: Problem with LEFT JOIN and long field [message #832828 is a reply to message #831947] Fri, 30 March 2012 12:32 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 1017
Registered: July 2009
Senior Member
I'm not sure what might have changed in EclipseLink to cause this. Does the problem occur if you change the type in A for id from long to Long?

Best Regards,
Chris

[Updated on: Fri, 30 March 2012 14:30]

Report message to a moderator

Previous Topic:Too long identifiers for oracle
Next Topic:Expecting EntityExistsException but getting DatabaseException (possible bug?)
Goto Forum:
  


Current Time: Thu Aug 21 08:23:29 EDT 2014

Powered by FUDForum. Page generated in 0.01644 seconds