执行这天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');
.....
省略部分赋值的代码..
我看了一下,还真没找到哪里错误!。
谢谢.各位朋友的指点..
