Hi,
My select with "concat" or "||" don'nt work in Informix940.
I'm using hibernate-3.0.3.
My select is "select id, codigo||nome from Area". The fields "codigo" and "nome" are of type String.

If I use "select id, codigo, nome from Area" (without ||), works.

The reported error is:
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.MethodNode
\-[METHOD_CALL] MethodNode: '||'
+-[METHOD_NAME] IdentNode: 'concat' {originalText=concat}
\-[EXPR_LIST] SqlNode: 'concatList'
+-[SQL_TOKEN] IdentNode: 'area0_.ARE_CODIGO' {originalText=codigo}
\-[SQL_TOKEN] IdentNode: 'area0_.ARE_NOME' {originalText=nome}


Any ideas how I can implement this select?

Thanks,
Juliano Claiton