From what I understand the problem doesn't lie in the Between cluase
If you look at the generated query you have something like this
select this_.BRCD_DLR_NO as y0_, this_.BRCD_PART_NO as y1_, ...
where TO_CHAR(BRCD_CRTE_TIME,'YYYYMMDD')BETWEEN '20110728' AND '20110729' and y1_=? This should have been this_.BRCD_PART_NO = ?
i think use of Projections is causing this to happen..
Cheers, Joy [SCJP 1.4, SCBCD 5.0]
get high on alcohol, algorithm or both
Joined: Oct 07, 2008
Thanks for reply,
I solve the problem as i use alias name like this.
subject: org.hibernate.exception.SQLGrammarException: could not execute query