Hi,

I'm getting an error while trying the select case .. when .. then .. else .. end.

ERROR :
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: Unexpected AST: org.hibernate.hql.ast.SqlNode
+-[CASE] SqlNode: 'case'
| +-[WHEN] SqlNode: 'when'
| | +-[EQ] SqlNode: '='
| | | +-[DOT] DotNode: 'home2_.BUILDERID' {propertyName=id,dereferenceType=4,propertyPath=builder.id,path=item.claim.home.builder.id,tableAlias=home2_,className=com.firstMonkey.beans.Home,classAlias=null}
| | | | +-[DOT] DotNode: 'home2_.BUILDERID' {propertyName=id,dereferenceType=ROOT_LEVEL,propertyPath=builder.id,path=item.claim.home.builder,tableAlias=home2_,className=com.firstMonkey.beans.Home,classAlias=null}
| | | | | +-[DOT] DotNode: 'claim1_.HOMEID' {propertyName=home,dereferenceType=1,propertyPath=home,path=item.claim.home,tableAlias=home2_,className=com.firstMonkey.beans.Home,classAlias=null}
| | | | | | +-[DOT] DotNode: 'lineitem0_.ClaimNbr' {propertyName=claim,dereferenceType=1,propertyPath=claim,path=item.claim,tableAlias=claim1_,className=com.firstMonkey.beans.Claim,classAlias=null}
| | | | | | | +-[ALIAS_REF] IdentNode: 'lineitem0_.ITEMID' {alias=item, className=com.firstMonkey.beans.LineItem, tableAlias=lineitem0_}
| | | | | | | \-[IDENT] IdentNode: 'claim' {originalText=claim}
| | | | | | \-[IDENT] IdentNode: 'home' {originalText=home}
| | | | | \-[IDENT] IdentNode: 'builder' {originalText=builder}
| | | | \-[IDENT] IdentNode: 'id' {originalText=id}
| | | \-[NUM_INT] LiteralNode: '5556'
| | \-[NUM_INT] LiteralNode: '1'
| \-[ELSE] SqlNode: 'else'
| \-[NUM_INT] LiteralNode: '2'


Can somebody help me?

Thanks,
Suja