even without the group by the query fails in exactly the same way! whats going on hibernate? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3995012#3995012 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3995012