HQL语句编译报错

[zhangwenmin]

======================运行报错
02-09 16：32：31.437 ERROR [ErrorCounter.java:33] <AST>:0:0: unexpected AST node: query
02-09 16：32：31.437 ERROR [ErrorCounter.java:33] right-hand operand of a binary operator was null
02-09 16：32：31.437 WARN [RequestProcessor.java:528] Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateQueryException

=======================SQL语句如下:

List list = getHibernateTemplate().find(
"select s.dangqianriqi,s.xiaoshoudian,"+
" sum(case when s.jihuadidian='黄埔' then s.taishu else '' end)+"+
" (select sum(f.taishu)"+
" from fnl_fwt.fwt_fenpei f"+
" where f.danqianriqi='2009-01-14'"+
" and s.xiaoshoudian=f.xiaoshoudian"+
" and s.dangqianriqi=f.jihuashijian"+
" and f.jihuadidian='黄埔'"+
" ),"+
" sum(case when s.jihuadidian='增城' then s.taishu else '' end)+"+
" (select sum(f.taishu)"+
" from fnl_fwt.fwt_fenpei f"+
" where f.danqianriqi='2009-01-14'"+
" and s.xiaoshoudian=f.xiaoshoudian"+
" and s.dangqianriqi=f.jihuashijian"+
" and f.jihuadidian='增城'"+
" )"+
" from fnl_fwt.fwt_jihualuru s"+
" where (s.xiaoshoudian,s.dangqianriqi,s.jihuadidian) in (select f.xiaoshoudian,f.jihuashijian,f.jihuadidian"+
" from fnl_fwt.fwt_fenpei f where f.danqianriqi='2009-01-14')"+
" group by s.dangqianriqi,s.xiaoshoudian"+
" order by s.xiaoshoudian"+);
return list;

[dawugui]

看不懂,帮顶.

[Andy__Huang]

你的sql语句在toad分析器运行通过了没有?
如果分析sql语句通过了,那就是你程序的问题

[fulianglove]

find????/
=============
请用createSQLQuery()

[adamxgl]

你的HQL语句的毛病，应该是缺半个标点符号，应该是缺个左引号或者是左括号
你好好仔细检查下你的语句吧