users@glassfish.java.net

Re: JPA query: null values in the query result

From: <glassfish_at_javadesktop.org>
Date: Fri, 11 May 2007 04:56:00 PDT

Hi Ales,

the first query "SELECT e.associatedEntity.name, e.description FROM ..." will not return any values for Entities not having an associatedEntity. The path expression 'e.associatedEntity' uses inner join semantics, so any entity without an associatedEntity cannot be returned. You find details in chapter 4.4.4 Path Expressions on page 84 of the spec.

It is strange that the second query "SELECT e.associatedEntity, e.description FROM ..." does not return values. I tried a similar query and I see nulls being included in the query result. I use the latest toplink version, but I'm not aware of any recent change that should effect the null handling.

Could you please provide a small test case that allows us to reproduce the issue? I propose you file an issue at https://glassfish.dev.java.net/servlets/ProjectIssues using the subcomponent entity-persistence. Please attach the test case to the issue.

Thanks!

Regards Michael
[Message sent by forum member 'mb124283' (mb124283)]

http://forums.java.net/jive/thread.jspa?messageID=216475