Hibernate Community • View topic - ParameterNode cannot be cast to org.hibernate.hql.ast.tree

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

ParameterNode cannot be cast to org.hibernate.hql.ast.tree

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

chacaman

Post subject: ParameterNode cannot be cast to org.hibernate.hql.ast.tree

Posted: Tue Apr 29, 2014 1:17 pm

Newbie

Joined: Tue Apr 29, 2014 1:13 pm
Posts: 2

guys thans for time and help
i have HQL Query using case and paramater and i get a error when i set the parameters
my query is:

Code:

SELECT 
IC.Sources, 
IC.Total, 
IC.Destination, 
IC.Where, 
ICP.Date, 
ICP.filedirectory, 
ICP.filename 
FROM IcmA AS IC, IcmProc AS ICP
WHERE IC.uniqueid = ICP.uniqueid
AND IC.Sources = :Num OR IC.Destination= :Num
AND CASE 
WHEN LENGTH(IC.Sources) = 1 OR LENGTH(IC.Destination) = 1 THEN
:NBalance
WHEN LENGTH(IC.Sources) > 1 OR LENGTH(IC.Destination) > 1 THEN
:NBalance
ELSE
:NBalance
END = :NBalance
AND(DATE_FORMAT(ICP.Date, '%Y/%m/%d') >= :fDate AND DATE_FORMAT(ICP.Date, '%Y/%m/%d') <= :tDate) ORDER BY ICP.Date DESC

Error:

Code:

java.lang.ClassCastException: org.hibernate.hql.ast.tree.ParameterNode cannot be cast to org.hibernate.hql.ast.tree.SelectExpression

Top

chacaman

Post subject: Re: ParameterNode cannot be cast to org.hibernate.hql.ast.tree

Posted: Tue Apr 29, 2014 8:38 pm