Getting java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.MethodNode

Question

My Query in java:

QUERY_STRING = "select a.seqNum,a.eventId,a.srcAddress,a.srcUser,REPLACE(a.message,',',' ') as message,a.createdTime,a.type,a.networkGroupName from Fraud a";

Getting Exception as Follows:

04:38:55,193 ERROR AppEntityManager:90 - java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.MethodNode
 +-[METHOD_CALL] MethodNode: '('
 |  +-[METHOD_NAME] IdentNode: 'REPLACE' {originalText=REPLACE}
 |  \-[EXPR_LIST] SqlNode: 'exprList'
 |     +-[DOT] DotNode: 'fraud0_.MESSAGE' {propertyName=message,dereferenceType=4,propertyPath=message,path=a.message,tableAlias=fraud0_,className=com.redshift.mgmt.entity.Fraud,classAlias=a}
 |     |  +-[ALIAS_REF] IdentNode: 'fraud0_.ALERT_ID' {alias=a, className=com.redshift.mgmt.entity.Fraud, tableAlias=fraud0_}
 |     |  \-[IDENT] IdentNode: 'message' {originalText=message}
 |     +-[QUOTED_STRING] LiteralNode: '',''
 |     \-[QUOTED_STRING] LiteralNode: '' ''

share the snap of your Fraud class

Ritesh Nair
– Ritesh Nair

2021-03-01 12:55:30 +00:00
Commented Mar 1, 2021 at 12:55 — Ritesh Nair
– Ritesh Nair, Commented Mar 1, 2021 at 12:55

Christian Beikov · Accepted Answer · 2021-03-02 09:36:37Z

5

The replace function is not known to Hibernate so it also doesn't know the result type that it should use for retrieving results from JDBC. Either register the function in your Dialect or wrap a cast around: CAST(REPLACE(a.message,',',' ') as java.lang.String)

answered Mar 2, 2021 at 9:36

Christian Beikov

16.6k2 gold badges36 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.MethodNode

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related