Hi, I'm using Hibernate version:3.01 and having some trouble with the aggregate functions such as max(). They seems to return an empty object array, if retrieved as list. Hibernate generates the propriate SQL and discover in fact one row. If retrieved as iterator, it work ok.

Query q = session.createQuery("select max(ue) ...");
UeBean ueBean = (UeBean)q.list().get(0);

the code above will cause a ClassCastException even though the data exists. q.iterate() works fine.

Thanks

I have noticed the same problem, but only when using the new ANTLR query parser, works fine with the classic parser.

Is there any solution to this?