[JBoss-user] [Beginners Corner] - getSingleResult behaviour mismatch for count() and sum() whe

[sventura <do-...@jb...>]

Is is normal that 

Number num 
  |         = (Number)entityManager.createQuery(
  |        "select count(*) from X x;")
  |        .getSingleResult();

works ok, and

Number num 
  |         = (Number)entityManager.createQuery(
  |         "select sum(x.id) from X x")
  |         .getSingleResult();

throws EntityNotFoundException when X has no entities at all?

I expected (since both functions are agregated) none will rice an exception and just return zero.

@Manifest
Too sorry in advance if this is documented else where.



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3904311#3904311

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3904311