[b]Hibernate 3.1.1[/b]

Hi All,

I am Using Weblogic 8.1 portal with hibernate as data access layer. I have a use case where:
1) user will rendered few records (read only) from database based on a criteria.
2) Say criteria matches 1000 records in DB. We are prefetching Primary keys array to calculate pagination scheme to be applied.
3) Now, on each page we will be displaying 25 records and these will be fetched depending upon the current page requested by user (by clicking a numberd link).
4) We are thinking of using "Open session in View" approach. But we cannot used AOP based interceptors as constraint is we cannot use jdk1.5, now we have left with Filters, but Filters will be more error prone interm of performance and managing transactions.

Please suggest appropraite approach for above scenario keeping in mind the constraints we have.

Thanks in Advance
Tushar Agrawal

I would
select the first 25 from the database
close the session
show them
when the news clicks to the next 25
select the next 25
close the session
show them


Regards Sebastian