Developers have asked us how to implement pagination in JDBC, seems like Teradata Dialect of Hibernate does not have the support implemented.
However, I have seen this working on viewpoint 13.11 in SQL Scratchpad. When the result has more rows than the rows in the app window, session stays in responding state and additional rows are fetched when the page is changed in SQL Scratchpad.
Is there someone who could answer this?
To help answer your question, I wrote this blog entry: