Please change the statement tag to create scrollable resultsets. Please also add a tag to return the total rowcount of a query without having to loop over the result set.
There are not currently any plans to allow for scrollable resultsets. As far as I know, JDBC does not support returning the total row counts without reading the rows of the ResultSet, only for obtaining the number of the current row.