My eviroment:

Hibernate 3.6.1
Hibernate tools 3.4.0
Eclipse helios

The problem:

select p.nombreproducto as nombre from Producto p order by nombre desc

this doesnt work hibernate tools throws this execption:

org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2452)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
...


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'nombre' in 'order clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
...

This some strange since the SQL that the Dinamic SQL preview show is:

0: string
-----------------
select
producto0_.nombreproducto as col_0_0_
from
Producto producto0_
order by
nombre desc


col_0_0_ ? i told to it is an alias 'nombre'

why?

select sum(v.total) as h from Venta v order by col_0_0_

and it works but if i put an h not
lol

why this happens?

Use "order by p.nombreproducto" in first example