Retrieving Hibernate query result as result set instead of list

Question

Heya, I m new to hibernate. I have to say it really simplifies everything for the SQL query. However, manipulating the returned result is a headache for me at the moment.

The result is returned as list. Most of the time I really want the result to be in result set so that I can manipulate it easier as using result set, you can specifies value by column name or index. In List, I am pretty much owned by own noobity.

In some ocassion, I can retrieve the list into a JSF data table and then just call the member directly. I cannot always do this. Don't ask me why. @.@ spinning head.

Is there a way to get resultset instead of list for hibernate?

You want Hibernate to return ResultSets instead of lists of entities? If so, why do you need Hibernate at all? — axtavt
– axtavt, Commented Mar 14, 2011 at 9:20
Show at least one example why ResultSet is better than List<Entity>. I really can't imagine of any one. — BalusC
– BalusC, Commented Mar 14, 2011 at 11:34
BalusC , I never say that ResultSet is better than List. I know hibernate is there for a reason. I just cant seem to parse the list according to the column name , for example in ResultSet I can do resultSet.getString(index) or resultSet.getString(columnName). In List, apparently I cant do so. Is there anything that I could do for that? — Haikal Nashuha
– Haikal Nashuha, Commented Mar 14, 2011 at 23:23
Although this thread is late, but this is the answer for others searching for this question: stackoverflow.com/questions/2605385/… — craftsman
– craftsman, Commented Feb 29, 2012 at 19:08

Vovka · Accepted Answer · 2016-03-16 12:13:57Z

4

You may need this if you have huge database and you can't fit List result into memory. Use scroll() instead of list():

Query query = session.createQuery(query);
query.setReadOnly(true);
setFetchSize(Integer.MIN_VALUE); //MUST use Integer.MIN_VALUE, other value=fetch all
ScrollableResults results = query.scroll(ScrollMode.FORWARD_ONLY);
// iterate over results
while (results.next()) {
    Object row = results.get();
}
results.close();

edited Mar 16, 2016 at 12:13

answered Mar 16, 2016 at 9:53

Vovka

5993 silver badges10 bronze badges

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

Comments

Pang · Accepted Answer · 2023-09-04 03:03:01Z

4

Slightly old thread but I cannot resist:

// Code for iterating over a list of objects
for(MappedClass mappedCless : list){
    String name = mappedClass.getName();
    String id = mappedClass.getId();
    // further logic
}

edited Sep 4, 2023 at 3:03

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Oct 4, 2011 at 14:57

DABrake

696 bronze badges

Comments

Haikal Nashuha · Accepted Answer · 2011-03-15 01:50:02Z

2

Ok, somehow I managed to make it work! Me so happy! For those who trying to find on how to manipulate the list returned by Hibernate query, basically what I did was..

//previous code
list = (List<MappedClass>)query.list();

From there the list shall contain mapped class and you can access it by iterator and subsequently uses getter to retrieve the value. Example

//previous code
for (int i =0; i<list.size(); i ++) {
  String name;
  String id;
  name = list.get(i).getName();
  id = list.get(i).getId();

  //add your data manipulation here
}

Hope this helps.

answered Mar 15, 2011 at 1:50

Haikal Nashuha

3,0487 gold badges50 silver badges68 bronze badges

2 Comments

BalusC Over a year ago

Oh, was that your actual problem? In the future, try to ask questions with more care. E.g. "How to iterate over a List of objects in Java?" instead of asking how to achieve a workaround and/or a different/wrong solution. There are by the way better/cleaner ways to do this, but I'll leave it up to you as exercise :)

Haikal Nashuha Over a year ago

uh..there is? Could you care letting me know? I am sorry if my question is not really understandable by the community, not a native english speaker.

Collectives™ on Stack Overflow

Retrieving Hibernate query result as result set instead of list

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related