Hi all,
I have a sql that retrieves more than 50k rows. I need to display these values in the selectbox(dropdown) on my
JSP screen.
When I do so, I get outOFmemeory Exception and operation timed out.
One solution I found was to use Statement.setMaxRows(int max).
But, does this restrict the rows to be displayed or fetches only the number of rows set(say for example 50). If yes, how to retrieve the other rows into the drop down?
Any other suitable suggestions?
Regards