Question

hibernate执行sql语句错误

sql语句：select a.recDt,a.nowValue,b.nowValue from (select nowValue,recDt from reg_condition where regId=11 and recDt between '2012-08-20 14:08:40.0' and now()) a left join (select nowValue,recDt from reg_condition where regId=12 and recDt between '2012-08-20 14:08:40.0' and now()) b on a.recDt=b.recDt order by a.recDt desc
报错信息：
Struts Problem Report
Struts has detected an unhandled exception:
Messages:unexpected token: ( near line 1, column 44 [select a.recDt,a.nowValue,b.nowValue from ( select nowValue,recDt from com.bhit.lubrioil.bhh.RegCondition where reg.id=11 and recDt between '2012-08-20 14:08:40.0' and now()) a left join ( select nowValue,recDt from com.bhit.lubrioil.bhh.RegCondition where reg.id=12 and recDt between '2012-08-20 14:08:40.0' and now()) b on a.recDt=b.recDt order by a.recDt desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 44 [select a.recDt,a.nowValue,b.nowValue from ( select nowValue,recDt from com.bhit.lubrioil.bhh.RegCondition where reg.id=11 and recDt between '2012-08-20 14:08:40.0' and now()) a left join ( select nowValue,recDt from com.bhit.lubrioil.bhh.RegCondition where reg.id=12 and recDt between '2012-08-20 14:08:40.0' and now()) b on a.recDt=b.recDt order by a.recDt desc]File:org/hibernate/hql/ast/QuerySyntaxException.javaLine number:54

联合查询的，sql语句在Mysql里运行完全正常，用hibernate执行就异常了，异常处为第一个from。。求大神解答。

Answer 1

错误是报的hql解析问题。
hql不是sql，你搞混了。
hibernate中的hql是以对象的形式来写的，你直接的sql肯定是不行的。
hql中，from不是表或者数据集，是用类或集合。
好好去看看hql应该怎么写。

追问

你仔细看看报错信息里面我是怎么写的，上面的sql是另外换算过的

Answer 2

貌似from 后面一般是跟domain类名，而且首字母大写，反正这样的查询我没用过，hibernate就是简化查询语句的。

Answer 3

程序里面的语句是hql语句，里面不写表名，应该写反转生成的类名。

追问

你仔细看看报错信息里面我是怎么写的，上面的sql是另外换算过的

Answer 4

用的是那个查询的方法？