Pals,
I am replacing an existing hql query like (simplified version),
"from Person pers" with,
"select new MyPersonRow(pers.lastName, pers.firstName, pers.otherDataObj) from Person pers"

where lastName, firstName are string properties in Person and otherDataObj is a user defined Type OtherData. Person maps to table PERSON and otherDataObj maps to table OTHERDATA which is a many-to-one association inside person.hbm.xml.

I notice that if otherDataObj returns null from database, then no results are returned. If it has a valid value in table, then correct 'person' list is returned. i.e. results are returned only if all properties queried in the projection query have valid return values from table. No result is returned even if one of the queried projection column is null in table.

Is this the expected behavior? Is there a work around where by I will still get 'person' list with otherDataObj property null inside the 'Person' objects?
Thanks,
Bzee

Pals,
Is there any solution to the projection query returning null result problem as illustrated below? Or if the query is not intelligible, I will reframe it?
thx.

using "pers.otherDataObj" as a select expression forces Hibernate to use an inner join...

Thanks Steve. I do see that from the results. But is there a work around for same? or possible to reframe the query such that results are returned even if pers.otherDataObj is null? I do want to use the projection query with dynamic instantiation and quite a few tries in modifying the hql failed for me.

My hql currently looks something like,



and I want to indicate that 'return me the results even if otherDataObj is null or empty ?

Hi,

I got the problem resolved by asking hibernate to make an outer join as in following hql:



where 'otherDataObj' has its own hbm.xml and table and Java class. In my caes, 'otherDataObj' was having a <many-to-one> association inside Person.hbm.xml.

But I'm still surprised how forcing a eager fetch like above solves the problem while making the original query I posted returns empty results.

do you understand the difference between an inner and an outer join?