Hibernate sum()函数为空的问题

[melodyfair1971]

private String hql = "select sum(TOTAL_TICKETS) from VoteTeacher";
public long getTeacherListMaxSize(final String hql) {
        long size = 0;
        try {
            size = (Long) this.getHibernateTemplate().execute(
                    new HibernateCallback() {

                        public Object doInHibernate(Session session)
                                throws HibernateException, SQLException {
                            Query query = session.createQuery(hql);
                            Long size = (Long) query.list().get(0);
                            return size;

                        }
                    });
        } catch (Exception e) {
        }
        return size;
    }

这样查询,返回的结果总是为0!
但是hql语句改为:

private String hql = "select count(TOTAL_TICKETS) from VoteTeacher";

可以返回记录的总数不为空!

[昨日凡阳]

这两个没有必然联系。count总数是求笔数。sum是求和。如果所有笔数的那个字段为0，sum为0。

[gGke_26]

先把语句拿到数据库里执行以下看是不是0。

[cong19900904]

hql写好点 试试 select sum(model.TOTAL_TICKETS) from VoteTeacher model

[melodyfair1971]

有大神给我指点一下吗.55