It looks like quite a few people have posted workarounds for this issue.
http://www.google.com/search?hl=en&q=SQL-SERVER+paging+limit&btnG=Google+Search For small result sets, there is no reason that you couldn't create your own form paging in
Java by writing all the rows to a list and only displaying the rows you like but I would make a serious attempt to limit the size of the results from the database first. A query that returns 50k rows could have a serious impact on your app.