I'm having some problems running a group by on a SQL Server query using Hibernate HQL. The table in question has NTEXT
columns. Note the two CONVERT
fields...
However, Hibernate chokes on this. Any suggestions on how best to pass this through to the Hibernate layer?
SELECT CONVERT(NVARCHAR(4000), A.DESCRIPTION),
CONVERT(NVARCHAR(4000), A.NEWS),
....
FROM ACCOUNT A
INNER JOIN A
...
GROUP BY CONVERT(NVARCHAR(4000), A.DESCRIPTION ),
CONVERT(NVARCHAR(4000), A.NEWS)
Error message:
[16:45:12.067] uncaught ERROR: No data type for node: org.hibernate.hql.ast.tree.MethodNode
+-[METHOD_CALL] MethodNode: '('
| +-[METHOD_NAME] IdentNode: 'convert' {originalText=convert}
| \-[EXPR_LIST] SqlNode: 'exprList'
| +-[METHOD_CALL] MethodNode: '('
| | +-[METHOD_NAME] IdentNode: 'nvarchar' {originalText=nvarchar}
| | \-[EXPR_LIST] SqlNode: 'exprList'
| | \-[NUM_INT] LiteralNode: '4000'
| \-[DOT] DotNode: 'account0_.Description' {propertyName=description,dereferenceType=ALL,propertyPath=description,path=a.description,tableAlias=account0_,className=classAlias=a}
| +-[ALIAS_REF] IdentNode: 'account0_.AccountID' {alias=a, className=com.recruitni.model.Account, tableAlias=account0_}
| \-[IDENT] IdentNode: 'description' {originalText=description}