HQL 查询语句问题? 朋友们帮忙看一下..

Question

执行这天Hql语句时报如下错误：
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: and near line 1, column 164：

HQL语句如下:

from BtripApplication btrip left join fetch btrip.applicationItemList btripItem
inner join btrip.organizationUnit orgUnit where

and ((btr.employee.ouCode like :code1 or btr.employee.ouCode like :code2)
and (btr.employee.ouCode like :orgUnitSearchPath or btr.employee.ouCode like :orgUnitSearchPath||'/%'))
and orgUnit.type is null or orgUnit.type =:orgGrounp
and :year is null or btripItem.from between to_date(:year||'-01-01','yyyy-MM-dd') and btripItem.toDate to_date(:year||'-12-31','yyyy-MM-dd');

.....
省略部分赋值的代码..

我看了一下,还真没找到哪里错误!。
谢谢.各位朋友的指点..

Answer 1

[quote]unexpected token[/quote]

错误是，你的HSQL语句中，含有非法字符。

核对下你的语句。