org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: saleRepBkrBkr near line 1, column 172 [select saleRepBkrBkr from com.sj.bayer.bcm2.model.SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: saleRepBkrBkr near line 1, column 172 [select saleRepBkrBkr from com.sj.bayer.bcm2.model.SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc]
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: saleRepBkrBkr near line 1, column 172 [select saleRepBkrBkr from com.sj.bayer.bcm2.model.SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc]
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: saleRepBkrBkr near line 1, column 172 [select saleRepBkrBkr from com.sj.bayer.bcm2.model.SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc]
and saleRepBkrBkr.regional.regionalCode ='BYRG001'/******这里少了个AND****/saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd')
where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001'
這里是不是少了一個 AND 來連接?????AND
saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc
ERROR [http-80-Processor19] SaleRepBkrBkrDaoHibernate.getRecords(110) | org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.DataException: could not execute query
select saleRepBkrBkr from SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' and saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') ) order by saleRepBkrBkr.id desc Count:select count(*) from SaleRepBkrBkr as saleRepBkrBkr where 1=1 and saleRepBkrBkr.status=1 and saleRepBkrBkr.regional.regionalCode ='BYRG001' and saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd') and to_date('2009-10-13','yyyy-mm-dd') )