Question

hibernate 执行sql语句出现queryException

2010-07-09 09:47:38.935 ERROR <!--- 执行HQL语句失败：select t.mainorgan,t.dsffdate,sum(t.amount),sum(t.totalamt),sum(t.totalcnt),sum(t.amount1)from DSFF_FEE t where t.organid=0100100014 group by t.mainorgan,t.dsffdate order by t.dsffdate desc --->
org.springframework.orm.hibernate.HibernateQueryException: in expected: t [select t.mainorgan,t.dsffdate,sum(t.amount),sum(t.totalamt),sum(t.totalcnt),sum(t.amount1)from DSFF_FEE t where t.organid=0100100014 group by t.mainorgan,t.dsffdate order by t.dsffdate desc]; nested exception is net.sf.hibernate.QueryException: in expected: t [select t.mainorgan,t.dsffdate,sum(t.amount),sum(t.totalamt),sum(t.totalcnt),sum(t.amount1)from DSFF_FEE t where t.organid=0100100014 group by t.mainorgan,t.dsffdate order by t.dsffdate desc]
net.sf.hibernate.QueryException: in expected: t [select t.mainorgan,t.dsffdate,sum(t.amount),sum(t.totalamt),sum(t.totalcnt),sum(t.amount1)from DSFF_FEE t where t.organid=0100100014 group by t.mainorgan,t.dsffdate order by t.dsffdate desc]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:293)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1530)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at org.springframework.orm.hibernate.HibernateTemplate$26.doInHibernate(HibernateTemplate.java:667)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:655)
at cn.com.agree.web.tapestry.database.dao.hibernate.BasicDaoWithLogger.executeHQLList(BasicDaoWithLogger.java:323)
at cn.com.agree.web.tapestry.database.spring.implement.BasicManager.executeHQLList(BasicManager.java:228)
at com.icbc.sh.isbp.pub.util.db.DbQueryUtil.brSumDsffFeeInfo(DbQueryUtil.java:2210)
这条语句在oracle数据库中执行是成功的，但是利用hibernate执行的时候就会报错了~~~
这是一条sql 语句，不是hql语句
利用的是hibernate去executeSql的

Answer 1

你使用的是什么数据库啊？oracle中你select后面的在group by中必须全部写上，否则报错。但是mysql好像不会有问题。也就是说这样
select t.mainorgan,t.dsffdate,sum(t.amount) as amount,sum(t.totalamt) as totalamt,sum(t.totalcnt) as totalcnt,sum(t.amount1) as amount1 from DSFF_FEE t where t.organid=0100100014 group by t.mainorgan,t.dsffdate,amount,totalamt,totalcnt,amount1 order by t.dsffdate desc

这样你在试试

Answer 2

group by t.mainorgan,t.dsffdate
你只对这2个字段group by 但是却对 totalamt totalcnt等字段 sum
这不符合sql规范，只能对group by的字段求和

Answer 3

where id=;;;和group by 冲突

Answer 4

hql语言写的有问题