Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.7

Full stack trace of any exception that occurs: net.sf.hibernate.QueryException: No column name found for property [controle] [ select MAX {a.controle} from mediator.Arq003 {a}]

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

How can i use MAX and createSQLQuery i'm not having a spected result please some give me a light.

thanks JP

http://www.hibernate.org/hib_docs/v3/re ... rysql.html
so

SQLQuery q = s.createSQLQuery( "select max( column_name ) as m_a_x from your_table_name ");
q.addScalar( "m_a_x", Hibernate.INTEGER );

List l = q.list();