MYSQL max函数返回的数据hibernate应该映射哪个数据类型?
mysql表中一个列status, 数据类型是int
有个SQL, 类似下面
select id, max(status) as newStatus from user group by id;
ResultTransformer rt=org.hibernate.transform.Transformers.aliasToBean(User.class);
session = this.getSession();
Query query = session.createSQLQuery(queryString).setResultTransformer(rt);
那在User类中, 应该在构造函数中给newStatus定义什么类型的呢?
我用了Integer, Long,
都报
org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of com.User.newStatus
...
Caused by: java.lang.IllegalArgumentException: argument type mismatch
下面这SQL也有类似情况
select id, case status when 1 then 1 else 0 end as newStatus2 from user;
这个newStatus2又该在构造函数中定义什么类型数据呢?
谢谢!