Java-Hibernate-Newbie: How do I acces the values from this l

Peter P3P · **Joined:** Sun Apr 11, 2010 7:22 am **Posts:** 4

I have this class mapped

Code:

@Entity
@Table(name = "USERS")
public class User {
 private long id;
 private String userName;
}

and I make a query:

Code:

Query query = session.createQuery("select id, userName, count(userName) from User order by count(userName) desc");
            return query.list();

How can I access the values(the result of the count) returned by the query?
I mean, how should I treat the query.list()? As a User or what?

If I try to cast the query.list.get(int) to User, I receive an exception.

aliaba · **Joined:** Tue Apr 13, 2010 2:23 am **Posts:** 7

no reply! now!
◎◎◎◎◎

nordborg · **Posted:** Wed Apr 14, 2010 2:34 am

Each entry in the list is an Object[] with the fields from the select statement in the same order. See section 10.4.1.3 in http://docs.jboss.org/hibernate/stable/ ... e-querying