"select new Constructor" in HQL

[nimo frey]

I have a strange failure:

I have a constructor with fullfills this:

select new Person(s.intValueA, s.intValueB) 
from Person s where s.name='hello'

(intValueA, intValueB are Integers)

this works.

This works, too:

select new Person(max(s.intValueA), max(s.intValueB) )
from Person s where s.name='hello'

But when I use the sum-aggregation:

select new Person(sum(s.intValueA), sum(s.intValueB) )
from Person s where s.name='hello'

this failure occurs:

org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [myObjects.Person] [select new Person(sum(s.intValueA), sum(s.intValueB) )

My Constructor:

public Person(){}
	

public Person(Integer intValueA, Integer intValueB) {
		this.intValueA= intValueA;
		this.intValueB= intValueB;
	}

Why does my Constructor not work, when I use the SUM-Aggregation???

[nimo frey]

Okay, solved.

The datatypes were wrong. I have used Integer instead of Long.