How can i access values returned by Hibernate Query?

Question

How can i access the elements from the list created as below? I tried creating a class containing a String and an int and cast to it but it doesn't work.

 List SOList = iadao.getSession().createQuery("select a.sistemOperare, count(a.sistemOperare) from User a, IstoricAfisari b, Banner c, Advertiser d where b.bannerId = c.id and c.advertiserId = d.id and b.userId = a.id group by a.sistemOperare").list();

Thank you

M Platvoet · Accepted Answer · 2011-06-23 08:51:54Z

3

This produces a List of Object arrays -> List<Object[]>

answered Jun 23, 2011 at 8:51

M Platvoet

1,6541 gold badge10 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dan Dinu Over a year ago

yes, which will have values like ['Windows',30]. How can i get to this values?

M Platvoet Over a year ago

if List<Object[]> represents to complete result set, Object[] represents a row in the result set. So I guess you are able to figure out what the values of the object array are ;)

Yhn · Accepted Answer · 2011-06-23 09:08:11Z

3

Since the createQuery(HQL).list() returns a List matching the indexes of the selected fields:

List SOList = ...
for (Object obj : SOList) {
    Object[] fields = (Object[]) obj;
    System.out.println("sistemOperare = " + fields[0] + " (count = " + fields[1] + ")");
}

Would print the results from the query, if any. According to hibernate documentation I could find (Since I'm more used to creating criteria for objects I want and then use Java for the rest).

answered Jun 23, 2011 at 9:08

Yhn

2,8252 gold badges15 silver badges10 bronze badges

Collectives™ on Stack Overflow

How can i access values returned by Hibernate Query?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related