History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: IDEADEV-22678
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Normal Normal
Assignee: Peter Gromov
Reporter: Steve Wardell
Votes: 1
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
IDEA: Development

Inspection does not recognize current_date() Hibernate function

Created: 17 Oct 07 01:59   Updated: 06 Dec 07 18:52
Component/s: Code Analysis. Inspection
Fix Version/s: Selena 7.0.2

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown

Build: 7,348
Fixed in build: 7,510
Severity: Medium


 Description  « Hide
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);



 All   Comments   Work Log   Change History      Sort Order:
Taras Tielkes - 25 Oct 07 16:17
HQL provides current_time() and current_timestamp() as well.

Are these recognized by IDEA 7.0.2?


Taras Tielkes - 25 Oct 07 16:20

Peter Gromov - 25 Oct 07 19:10
Yes, they're supported