大侠帮忙!!!!!!!!!!Hibernate HQL 子查询 的问题, 急,在线等!!!!

[kevinhewanjun]

nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 134 [select count(*) from com.hibernate.dao.Customer c where c.tracetype = '1' and c.company.comid = 1 and c.cusid in ( select cusid from (select cusid, count(*) as times from com.hibernate.dao.Tracerecord where tracetime >= '2008-05-05 00:00:00' and tracetime <= '2008-05-05 00:00:00' group by cusid ) where times <= 1 and times >= 2 )]

等高手帮忙处理上面一句代码.

[jdlsfl]

sql语法问题，什么数据库
在数据库中执行sql试试看

[maodie007]

好像是日期格式的错误 '2008-05-05 00:00:00'
你最好以参数的形式试下
如
Query query=session.CreateQuery("from tablename where date between ? and ?").setParameter(0,date1).setParameter(1,date2);
date1和date2
必须为日期类型数据
试下吧

HQL 和SQL还是又点区别的 SQL 可以直接用类似tracetime >= '2008-05-05 00:00:00'

[kevinhewanjun]

我用的是oracle,时间我用的是字符串,在数据库中执行下面SQL没问题:
select cusid from (select cusid, count(*) as times from Tracerecord where tracetime >= '2008-05-05 00:00:00' and tracetime <= '2008-05-04 00:00:00' group by cusid) where times <= 1 and times >= 2;
但用HQL就是不行.

[kevinhewanjun]

问题已解决.是写HQL时Tracerecord t的字段cusid必须写成t.customer.cusid.
哎,老是忘记表关系中hibernate的表示法.