HQL报错帮忙看下，感激不尽

nana04720 2010-01-21 05:45:05

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]

...全文

102 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

andyjiang 2010-01-21

打赏
举报

and 没有

qianmz 2010-01-21

打赏
举报

少了and

qianmz 2010-01-21

打赏
举报

and saleRepBkrBkr.regional.regionalCode ='BYRG001' and saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd')

fantasy2436 2010-01-21

打赏
举报

為什么你最后多半個右括號？

sun_zhicheng 2010-01-21

打赏
举报

楼主你去命令行执行下就能看到错误发生在哪里，你这样贴出来谁知道啊！！！

nana04720 2010-01-21

打赏
举报

[Quote=引用 3 楼 warison2008 的回复:]
我看见啦，
and saleRepBkrBkr.regional.regionalCode ='BYRG001'/******这里少了个AND****/saleRepBkrBkr.dates between to_date('2009-10-13','yyyy-mm-dd')
[/Quote]
谢谢，不过又出现了新的错误
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') )

zw365579102 2010-01-21

打赏
举报

hibernate有的函数是不支持的，查看一下是否支持函数to_date

changshoujun 2010-01-21

打赏
举报

saleRepBkrBkr.status='1'?

fantasy2436 2010-01-21

打赏
举报

select saleRepBkrBkr from com.sj.bayer.bcm2.model.SaleRepBkrBkr as saleRepBkrBkr
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