Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Next "n" records

 
Jamie Jackson
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My colleague has a problem with her Hibernate-driven Web app. She's got a query returning 10000+ records, and she's getting out of memory exceptions.

It would be ideal if she could just retrieve the chunk of records that she needs, as opposed to the whole resultset.

I'm not sure how to approach the next "n" records issue in Java, and further complicating things is the fact that she's got column sorting on the HTML table.

Is there a treatise on this somewhere?

Thanks,
Jamie
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65338
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is an entry in the JSP FAQ that might be a good starting point.
 
Jamie Jackson
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, that looks like a good start.

Thanks!
Jamie
 
Jignesh Patel
Ranch Hand
Posts: 626
Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You may like to see this link too.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic