Hibernate version: 3.0

String sqlQuery = "SELECT * FROM PRODUCT WHERE PRODUCT.ID = 1"
SQLQuery query =

ems.comm.model.hibernate.EMSPersistentManager.instance().getSession().createSQLQuery(sqlQuery);

List resultList = (List) query.list();

Product p = (Product) list.get(0);

I am getting a ClassCast exception when i fetch the found objects in the usual way, with casting.. This is the does not happen when i fetch other object using way above.

When I print out the object name it the object type is something like" Exception: [Ljava.lang.Object; ]"

How do we check for the OBJECT in the list returned ?

Thank you in advance.

Print yourObject.getClass().getName(). Or just set a breakpoint to see :-)

Hi,

Sorrie for not making my questions clear. I did print and breakpoint to see the object. Its suppose to give me an product obj instead of just an Object .

Any otherways for me to determine what type of object it is?

Hi,

I think if you do not define the class of the entity to be returned list() will always return a list of Object[] since Hibernate does not know that you want to get a Product object back.

Try