(求助)hibernate中用原SQL写子查询的问题

[绿豆眼睛]

以下SQL在List tmpList = getSession().createQuery(base.toString()).list();中运行出错,不知道是什么问题望高手解答下
SELECT Me.senddate, Me.datacount
FROM (SELECT Ml.senddate AS senddate, count(*) AS datacount
FROM Maker Ma,
Mlist Ml
WHERE Ma.flag = '1'
AND Ma.tcode = Ml.tcode
GROUP BY Ml.senddate
ORDER BY Ml.senddate DESC) Me
WHERE rownum <= 7
异常:SystemError:findMlistListnullin expected: SELECT [ SELECT Me.senddate, Me.datacount FROM ( SELECT Ml.comp_id.senddate AS senddate, count(*) AS datacount FROM model.Maker Ma, model.Mlist Ml WHERE Ma.flag = '1' AND Ma.tcode = Ml.tcode GROUP BY Ml.comp_id.senddate ORDER BY Ml.comp_id.senddate DESC) Me WHERE rownum <= 7 ][Ljava.lang.StackTraceElement;@df9252

[zxh2208180]

问题在SELECT Ml.senddate AS senddate, count(*) AS datacount,
表达式(count(*)) 和 普通字段不能一起用..

[crazy_he]

我记得是不是应该写成这样子 getSession().createSQLQuery(sql)

[sureyor]

恩,同意楼上,SQL语句没有问题,很正确,错误的在于执行SQL的方式不对
createQuery是执行HQL的
而createSQLQuery菜市执行原SQL的

[jingtao8177]

up