HQL Query return type

[Ali Ekber]

I am working on an HQL hibernate query and a simplified version of the code is below:

List messages = new ArrayList();
Session session = getSession(false);
String hqlSelect = "select id, messageText, uId from Message where uId = :userId";
Query query = session.createQuery(hqlSelect);
query.setString("userId", userId);
messages = query.list();

Iterator it = messages.iterator();
while (it.hasNext()) {
System.out.println("message -> "+ ( ((Message) ((ArrayList) it.next()).get(0)).getMessageText()));
}

I am getting ClassCast exception inside the while loop when I try to type cast the iterator to ArrayList or to Message. I think iterator is coming back as Object.

Is there any way I have the result set (List) returned as an array list of Message classes?

[Chandra Bhatt]

System.out.println("message -> "+ ( ((Message) ((ArrayList) it.next()).get(0)).getMessageText()));

Why are you casting to ArrayList?
Each element returned by calling iter.next() IS A Message.
(Message(it.next())).getMessageText(); should work.

[Adeel Ansari]

Session session = getSession(false);
String hqlSelect = "select id, messageText, uId from Message where uId = :userId";
 
Query query = session.createQuery(hqlSelect);
query.setString("userId", userId);
 
List<Object[]> messages = query.list();
while (Object[] objArray : messages) {
  System.out.println("message -> "+ objArr[1]);
}

Hope this would work. I haven't tried it though. Even if it doesn't work. it will definitely give you a hint.

[Adeel Ansari]

Why SQL query? Try this...

        DetachedCriteria dCriteria = DetachedCriteria.forClass(Message.class, "m");
        Session session= getSessionFactory().openSession();
 
        Criteria criteria = dCriteria.getExecutableCriteria(session);
        criteria.add(Restrictions.eq("m.userId", userId));
        List<Message> messageList = criteria.list();
        for (Message msg : messageList) {
           System.out.println("message -> "+ msg.getText());
        }
 
        session.close();

[Paul Sturrock]

Why SQL query? Try this...

You mean HQL? But you make a good point, using Criteria in stead of HQL is a better way to go.

[Adeel Ansari]

Originally posted by Paul Sturrock:
You mean HQL?

O'Yeah. Actually, when it starts with a select, it looks SQL to me. You know such queries - without any particular column/s to project - which starts with a from looks more HQL, IMO.
[ October 20, 2008: Message edited by: Adeel Ansari ]