到底应该怎么执行hibernate的max等聚合函数

[shixueli]

我在执行时Integer c = (Integer)dbt.getSession().createQuery("select sum(articleId) from Article").uniqueResult();出现异常：

Exception in thread "main" java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.AggregateNode
\-[AGGREGATE] AggregateNode: 'sum'
\-[IDENT] IdentNode: 'articleId' {originalText=articleId}

at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:140)
at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:702)
at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:531)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:645)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
at com.lj.hibernate.Test.main(Test.java:16)

[benq998]

articleId这个名字对马，是不是写错了。

[Octer]

List list = dbt.getSession().createQuery("select sum(model.articleId) from Article as model").list();

Long count = (Long)list.get(0);
看看这样应该可以吧!

[shixueli]

不行的拉.Exception in thread "main" org.hibernate.QueryException: could not resolve property: articleId of: com.lj.form.Article [select sum(model.articleId) from com.lj.form.Article as model]

[shixueli]

是不是你的model有问题???

model是什么东东?要怎么设置?

[shixueli]

嗯,好使了. 谢谢你拉

[Octer]

我试过了，我这里对ID(类型 long)进行sum,没什么问题

could not resolve property: 是不是你的model有问题???