Hibernate version: 2.1


Name and version of the database you are using: Oracle 8i


CODE HIBERNATE HSQL
List _list_ = session.createQuery(" select cout(*) " +
"from AuditServicio as a " +
"where a.Id = 1146 "+
"group by a.id,a.idServicio " +
"order by count(*)").list();

SQL*PLUS

select count(*)
from Audit_servicio
where id =1146
group by id, id_servicio
order by count(*)

Results Hibernate
1
1
1
.....
1
1

Results SQL*PLUS
COUNT(*)
----------
1
1
2
2
3
6
6
6
9
14
15

COUNT(*)
----------
29
61
77
108
134


i can't understand, could help me, please

Hibernate 2.1.? What is the minor version number? Not that it will make that much of a difference, but everything helps.

Can you confirm that it is using the same SQL? Within your configuration, set the show_sql property to true and compare the actual SQL that is generated with what you are using in SQL*PLUS.

Is your problem from a type ????

In your Hibernate SQL you have :

List _list_ = session.createQuery(" select cout(*) " +
"from AuditServicio as a " +
"where a.Id = 1146 "+
"group by a.id,a.idServicio " +
"order by count(*)").list();


Should it have been "select count" and not "select cout" ????

Obviously this could have just been a typo in your documentation of the problem and nothing to do with the problem .....

Mike.

thanks so much, watching the query with sql_query true
tell me which the table where are doing the query was other


please realy sorry my languages ^_^U

What was the actual SQL that Hibernate was generating? Inquiring minds want to know!

Don't blame Hibernate. 99% of posts titled "bug in Hibernate" are simple user error

it's a simple user error, i'm wrong with table in the map file,
in the sql*plus i'm using the Audit_servicio but the hibernate map file "AuditServicio.hbm.xml" i'm using audit_user_servicio.

excuse me by the annoyance.