Hibernate version: 3.2.1

Mapping documents:

<class name="Utente" table="utente" >
<id name="id" type="int">
<column name="IdUtente" />
<generator class="assigned" />
</id>
<property name="userName" type="string">
<column name="UserName" length="20" not-null="true" />
</property>
<property name="password" type="string">
<column name="Password" length="50" not-null="true" />
</property>

</class>

Full stack trace of any exception that occurs:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column 'utente0_.UserName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.



Name and version of the database you are using: SQL Server 2000

The generated SQL (show_sql=true):

select
utente0_.IdUtente as IdUtente27_,
utente0_.UserName as UserName27_,
utente0_.Password as Password27_
from
ster.dbo.utente utente0_
group by
utente0_.IdUtente



the error occur when i use the following HQL query:

from Utente utente group by utente

the problem is that the select correctly select all the field of the Utente class, but the group by not.

Is Hibernete that is wrong or i made some error ?

probably my error,

at page 152 of the hibernate manual i'va found this