A query with HQL

[Ravi Kiran Va]

Hi ,

I am praticing Hibernate HQL through Eclipse HQL Editor .

Could anybody please let me know why the FIrst Statement is executed while the second throws an Error .

select NAME , PASSWORD from Users 1st query

select * from Users 2nd query

Please suggest . Thank

[Paul Sturrock]

Impossible to say without knowing what error is thrown. Both look OK (though the property names in the first look a bit suspect for a Java class).

[Ravi Kiran Va]

Thanks Paul ,

You were correct that without seeing the POJO types we cant say whats the problem in case of writing HQL .

Assume taht this is my code inside a Java Object .

@Namedquery(name="myquery" query="select ename from emp")
Query query = session.getNamedQuery("myquery");

I just want to ask that , is it possbile to use normal SQL queries within @Namedquery , or should it be HQL queries only

Please advice , thanks .