Native SQL in hibernate

[Felissa]

I must obtain the minimum value of a field of a table, don't know how can I do that with HQL I tried to use SQL, with the method createSQLQuery for Session, but it doesn't work.

It throws an error saying that certain column does not exist, but the rare thing is that I never talk about that column. Do you know how can I resolve this?

Felissa

[Marcus]

Have you tried this?

Code:

sess.createQuery(select min(usu.sueldo) from Usuario usu))list.get(0)

Greetings
Marcus