Sorry if this has already been asked many times before..

I have a few thousand rows that I want to display in a JSP page with the output of
a JPA query.

I know there are better ways to do this like using paginated result sets etc, but what I am
not sure about is :-


If I do iterate over a large number of rows (single table / fetch joins), will the result set
ever "close" while I am in the JSP, becuase its no longer in a transaction ?

In my DAO, I use @Transactional and set it to be read only.


Thanks