Hi all,
New to hibernate and have a question.

The following works just fine;
List Users = session.CreateQuery("from users").list();

Iterator i = Users.iterator();
while (i.hasNext()){
Users usr = (Users) i.next();
System.out.println(usr.getName());
}

but when i try
List Users = session.CreateSQLQuery("SELECT * FROM Users").list();
I get an error message here:
Users usr = (Users) i.next(); <--- complained about casting object to User!!

Thanks,

When you are using you have to pass native sql query. you cannot pass HQL query.

There is an entire chapter in the documentation about native queries in the documentation which, among other things, will tell you how to return entities: http://docs.jboss.org/hibernate/stable/ ... rysql.html

in the query you have to add the entity.
List Users = session.CreateSQLQuery("SELECT * FROM Users").addEntity(Users.class).list();

yup i did that, i forgot to write the correct form here in fourm, thanks.



I looked at it before i posted but will check it out again, thanks.



Thanks, i will give this a try.