Jan 2nd, 2012, 10:09 AM
Displaying a large number of rows from JPA getResultList
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.