Eclipse Community Forums: EclipseLink » Problem with LEFT JOIN and long field

Help

Home

Home » Eclipse Projects » EclipseLink » Problem with LEFT JOIN and long field

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

Problem with LEFT JOIN and long field [message #831947]

Thu, 29 March 2012 14:59

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

Report message to a moderator

Re: Problem with LEFT JOIN and long field [message #832828 is a reply to message #831947]

Fri, 30 March 2012 16:32

Chris Delahunt

Messages: 1389
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 18:30]

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:37:23 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter