shushali123
shushali123
2015-01-04 06:18

关于hql语句使用聚集函数的问题

  • hql语句
  • 数据库

select sum(counts) from(select count(c) as counts from ChooseJudge c where 1=1 union all select count(f) as counts from FillVacancy f where 1=1)
在数据库运行正常,在java中就报错
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 26 [select count(counts) from(select count(c) as counts from com.zjtl.manage.entity.ChooseJudge c where 1=1 union all select count(f) as counts from com.zjtl.manage.entity.FillVacancy f where 1=1)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答