I'm trying to run the following query on a MySQL InnoDB database (MySQL InnoDB dialect set) (just an example):

select sum(m.id) from markers m

where markers is a table for mapped entities and id is an integer field in that table.

<class name="controller.dto.MarkerDTO" table="MARKERS">
<id name="id" type="int" column="id">
<generator class="hilo">
<param name="table">marker_dto_hi_value</param>
<param name="column">marker_dto_next_value</param>
<param name="max_lo">100</param>
</generator>
</id>

etc

I get the following exception:

java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.AggregateNode
\-[AGGREGATE] AggregateNode: 'sum'

at org.hibernate.hql.ast.SelectClause.initializeExplicitSelectClause(SelectClause.java:136)
at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:440)
at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:351)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.afterQuery(HqlSqlBaseWalker.java:126)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:471)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)

so on

I looked into hiberante sources and found that the sum() function doesn't have it's own return value (which is reasonable), and according to the logic should take it from its first child node in the AST tree. But getFirstChild() returns NULL (here I think is the problem). The package I've downloaded doesn't contain sources for AST functions (at least I didn't find them), so I cannot figure out why it doesn't work properly.

Thanks in advance

This is working perfectly for me in HB 3.1

Thanks for your reply, but upgrading from 3.0 to 3.1 didn't help.

Anyway, I think I can make it work via ODBC direct connection or maybe switch to MySQL 5.0 and use views...

I had the same problem working with hibernate 3.0.5 and MySQL 5 but I used the following code as a workaround:


Mapping conf: