im using IBM DB2

when i use case statement in my named query (HQL)
im getting the following error



[4/10/07 14:43:23:937 GMT+05:30] 5d70923e PARSER E org.hibernate.hql.PARSER *** ERROR: <AST>:0:0: unexpected AST node: query

[4/10/07 14:43:23:937 GMT+05:30] 5d70923e PARSER E org.hibernate.hql.PARSER *** ERROR: <AST>:0:0: unexpected AST node: query

[4/10/07 14:43:23:953 GMT+05:30] 5d70923e PARSER E org.hibernate.hql.PARSER *** ERROR: <AST>:0:0: unexpected AST node: query

[4/10/07 14:43:23:953 GMT+05:30] 5d70923e PARSER E org.hibernate.hql.PARSER *** ERROR: <AST>:0:0: unexpected AST node: query
[4/10/07 14:43:23:969 GMT+05:30] 5d70923e SystemErr R java.lang.NullPointerException
[4/10/07 14:43:24:031 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.CaseNode.getDataType(CaseNode.java:15)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.SelectClause.initializeExplicitSelectClause(SelectClause.java:134)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:440)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:351)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.antlr.HqlSqlBaseWalker.afterQuery(HqlSqlBaseWalker.java:126)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:471)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:151)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
[4/10/07 14:43:24:047 GMT+05:30] 5d70923e SystemErr R at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
[4/10/07 14:43:24:078 GMT+05:30] 5d70923e SystemErr R at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
[4/10/07 14:43:24:078 GMT+05:30] 5d70923e SystemErr R at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:38

Gonna be pretty hard to tell you anything without the HQL statement.

Hi Ananasi


Following is my query in SQL, i need to use it as HQL
Please correct the syntax

select b.org_cd,case when b.mgr_alt_id_key_val is null then (select mgr_alt_id_key_val from tuporg where org_id=85713 and del_ind='N')
when b.mgr_alt_id_key_val is not null then (select gv_1_nm from tupprod_alt_id c,tuporg d where c.alt_id_key_value=d.mgr_alt_id_key_val
and d.org_id=85713 and d.del_ind='N' )END AS MGR_ALT_ID_KEY_VAL
from tuporg b where B.org_id=85713 and B.del_ind='N'

You usually gets this error if you are trying to use SQL aggregate functions with the HQL

Dont combine SQL with SQL, check your query