I am using Hibernate with Spring and received a validation error that I believe is incorrect. In the code snippit below, I receive a type mismatch on "current_date()" with the error message that java.util.Date type is expected. However, current_date() should fulfill this type.
I String HQL =
"from CASE a where a.case_id_nmbr in ("+
"select distinct pad.plnadmCaseIdNmbr from Planadministration pad," +
" CASE cs, Assignment asg "+
" WHERE pad.plnadmOngoingAsmptnDate <= current_date() "+
" and cs.case_cascateg_code is not null "+
" and cs.case_cascateg_code <> 0 "+
" and asg.assignDeptDivCode in (:divisions) "+
" and asg.assignEndDate is null "+
" and asg.assignCaseIdNmbr=pad.plnadmCaseIdNmbr "+
" and pad.plnadmCaseIdNmbr = cs.case_id_nmbr "+
" and 0 = "+
" ( select count
" +
" from CaseMilestone cml "+
" where cml.casmlstnCaseIdNmbr = cs.case_id_nmbr " +
" and (cml.casmlstnFinalizedFlag is null or cml.casmlstnFinalizedFlag = 'N') "+
" and not (cml.casmlstnReftypeCode in (:TPDRefTypes) )" +
" and cml.casmlstnReftypeCode not in " +
" (select ref.reftype_code FROM ReferralType ref WHERE ref.reftype_archive_flag='Y')"+
" ) "+
") " +
"order by a.case_id_nmbr";
Query query = session.createQuery(HQL);
Are these recognized by IDEA 7.0.2?