统计一个用户的上传，下载量
select u.department depart ,(select count(lu.logUploadId) from FtpLogUpload lu where lu.ftpUser.userId=u.userId) upc ,(select count(ld.logDownloadId) from FtpLogDownload ld where ld.ftpUser.userId=u.userId) doc from FtpUser u where u.state=1 order by upc desc
报错：
org.hibernate.QueryException: , expected in SELECT [ select u.department depart ,(select count(lu.logUploadId) from FtpLogUpload lu where lu.ftpUser.userId=u.userId) upc ,(select count(ld.logDownloadId) from FtpLogDownload ld where ld.ftpUser.userId=u.userId) doc from FtpUser u where u.state=1 order by upc desc ]
at org.hibernate.hql.classic.SelectParser.token(SelectParser.java:175)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
at org.hibernate.hql.classic.ClauseParser.end(ClauseParser.java:113)
at org.hibernate.hql.classic.PreprocessingParser.end(PreprocessingParser.java:122)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:29)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:216)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:185)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
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:1623)
你用hibernate回调试试看
关于hibernate回调的例子可以参考
[url]http://aidiyuxin.iteye.com/admin/blogs/224850[/url]