How can I "paginate" the result instead of get it all in memory?

[noelopezmiguez]

Hello!

I have a problem and maybe someone can help me to solve it :)

I am getting a memory error when generating a report with jasper report (it is an excel) because the query I am launching is too hard so my question is, ¿can I do something to get the results like "paginated" instead of keep all of them in memory? Maybe something like this ¿? http://www.javalobby.org/articles/hibernatequery103/?source=archives

Thanks in advance!

[hozawa]

JasperReports supports Virtualizer to support large reports.

http://community.jaspersoft.com/wiki/virtualizers-jasperreports

[noelopezmiguez]

Thanks for the answer.

We are already using the JRSwapFileVirtualizer but our problem starts before that, when our query gets the list with all the results and we send them to Jasper, we need to find a way to split that results in smaller parts to do not get an out of memory error.

[hozawa]

Why not just create paramters to pass to your sql statement to limit records to fetch. For example. there's a limit and offset in mysql select statement, Just set values for these values from parameters.