Hi,
I am trying to execute the query: SELECT Ident_current('my_table') AS EXPR1 on the SQL server we use as our db server. But I get the following error message:
Code:
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.MethodNode \-[METHOD_CALL] MethodNode: '(' +-[METHOD_NAME] IdentNode: 'IDENT_CURRENT' {originalText=IDENT_CURRENT} \-[EXPR_LIST] SqlNode: 'exprList' \-[QUOTED_STRING] LiteralNode:
Any light on this?
My other question is:
Is there a way for Hibernate to just execute a query like this (or a query to get the count/sum/avg etc) without having a mapping bean defined to represent/capture the result, so that we can just retrieve the result from resultset to our own variables and not persist them.
Thank you!