Why is the query returning null when I execute the following code:

Query query = session.createQuery("select sum(wl.hours) from WorkLog wl where wl.owner.id = ?");
query.setString(0,"myId");
Object result = query.uniqueResult();

------------------

The query is just trying to get me the sum of hours. I'm expecting this to return a Double which is the type for my hours property. I see in the logs that hibernate generates the right SQL and if I execute it in an SQL editor it returns the expected results. But when runed within hibernate it returns null,
Any ideas?


Thanks

Hello,
Of what type is the wl.owner.id in the database? Is it of type char?
If so, make sure, that the length of the string is equal to the size in the database (--> padding).

Hope this helps!
Urs

I seem to be experiencing the same issue, a few years later. Is this expected behavior? Here's an example SQL output:



My projection is quite simple: setProjection(sum("amount")); I'm not setting the ResultsTransformer.

When I call uniqueResult() I get a null value, which is strange - I know there are zero rows but I think hibernate should return 0 in that case, shouldn't it?