I can use the methods Session.save() and Session.load() without problems, when i save, the table is updated, when use the load method i can convert the objetc in this way (MyClass) Session.load (MyClass, objid) and everything is allright.
When i use query.list() to retrive all records, this list is created with the correct size (equal to the numbers of records), but if i try of cast the objects of my list, the next error appear : "CastClassException".

Can you post the code where you make the query and where you cast an item in the list?

Thanks for you help, but the problem was that i try to use the next sintax:
"Query query = session.createQuery("select p.id, p.descripcion from prueba p"); "
and to retrieve the list
"query.list()"

In the reference manual of hibernate i find a diferent sintax, then change my code to:

Prueba fritz =new Prueba();
Query query = session.createSQLQuery("select {fritz.*} from prueba {fritz}", "fritz", Prueba.class);

to retrieve list: rows = query.list();

in this way i don't need cast the list elements!!

Thanks for your answer!!!!!!

the queries are different
the first return a list of object[]

the second returns a list of object

just change the first from

to


and read the doc
http://www.hibernate.org/hib_docs/refer ... hql-select

Anthony:
When i create the query with this , i retrieve a RuntimeException with this message "in expected"
Do you know the cause of this???
Thanks for you time!!!!

When asking questions, give at least:
the Hibernate version
your mapping documents
the Java code between sessionFactory.openSession() and session.close()
the full stack trace of any exception that occurs
the name and version of the database you are using
a debug level Hibernate log excerpt is also appreciated