I'm using HQL as opposed to the Criteria API (which I usually use), and i'm running into a problem where the Objects I get back come back as type Object. When I try to cast them, I get ClassCastExecptions (yes, i'm casting them to what's supposed to be the correct class).

Here's my query:
List list = session.find("from com.xxx.xxx.bizmodel.survey.UserAnswerImpl as userAnswer inner join userAnswer.answer as answer inner join answer.question as question inner join question.survey as survey where survey.id = ?", new Long(aSurveyId), new LongType());

The cast to UserAnswer whcih UserAnswerImpl implements is failing. What in the world am I doing wrong here?

Please post the code if we need to help ya', ok ? ;)


And secondly without even looking at the query I would like you try to e.g. print the type of the elements in the result you get from find - then you might see that it is possible an Object[], meaning it returns more than one item per row.

Thanks for the help... I was indeed getting Object[] back from my query because I wasn't using "select" in my query.