Paginated Hibernate data set

I 've been spending almost a week trying to create a paginated report with an Hibernate data source and a data set. The main problem we have is that our tables are dammed huge and we have to report them entirely!, so we MUST implement paginated queries to avoid bringing the whole table.

I tried setting the "Max results" parameter in the Hibernate data source and the "Max number of rows to fetch from data source" on the data set, but it seems to ignore theese parameters as the query that is excuted brings the whole table.

Does anyone faced a similar problem?

My las resort is to run the HQL right from java, create that way a dataset and somewhow pass this data set to the report.

Any help will be useful
Thanks in advance

Find more posts tagged with

Comments

mwilliams

Hi eldiegolp,

What version of BIRT are you using?

eldiegolp

Birt 2.5.1 and Hibernate 3, i dont really know the Hibernate oda driver version.

Thanks for your support,
Diego

mwilliams

Diego,

I don't have a hibernate dataSource to test on, but with 2.5.1, I tested with the sample database and the "Max number of rows to fetch from data source" setting works as expected with it.