JDBC driver pagination support | Teradata Developer Exchange

MicroStrategy reporting using Teradata Unity Director 14.00 vineeta.v

What's new in Teradata Mapping Manager 2.1.5 ccurry

Teradata Studio products - choosing the right client tool fgrimmer

Statistics collection recommendations – Teradata 14.0 carrie

Unity Director 14.00 & Unity Loader 14.00 now available schemanske

Teradata Studio 14.02 now available fgrimmer

Preserving Data Integrity when TPT Export to Stream Job Restarts TonyL

Using the ResUsageSAWT table to Monitor AMP Worker Tasks carrie

Database Tasks that Run on the Parsing Engine carrie

Speed up Large Object (LOB) retrieval with CommandBehavior.SequentialAccess NetFx

Elevating Parsing Priority carrie

How to simplify your statistics collection with a queue table dnoeth

Teradata Viewpoint 14.01 Release gryback

Teradata Data Lab 14.01 Release gryback

New opportunities for statistics collection in Teradata 14.0 carrie

Are AMP Worker Tasks used by FastExport in Response Mode? carrie

A Day in the Life of a Unity Data Mover Job KBlack

Preserving Data Integrity when TPT Export to Stream Job Restarts TonyL

TD 14.0 - The other partitioning enhancements PaulSinclair

Introducing TDM into a production Dual System environment PaulW

Teradata Multi-System Manager (TMSM) 14.0 Release gryback

Teradata Express 14.0 for VMware now available Cliff L

Aster's Linear and Logistic Regression functions Teradata_Mark

A reliable rebooting mechanism for Data Mover Services yeyuancn

Flow Control and Spawned Work carrie

Changes to the TASM AMP Worker Task Event in Teradata 13.10 carrie

Teradata Alerts / CAM 14.0 released gryback

Teradata 13.10 Statistics Collection Recommendations carrie

Managing Teradata Data Lab users with TASM stevehurlbut

TTU Install Documentation info-eng-team-td

Welcome to the Teradata Forums. Read the guidelines on posting. Email notifications and RSS feeds are available, and also a chronological list of all forum activity.

Duri83 16 posts Joined 01/12

16 Mar 2012

JDBC driver pagination support

Hi,

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?

Thanks,

Yuri

Tags:

tomnolan 204 posts Joined 01/08

19 Mar 2012

To help answer your question, I wrote this blog entry:

http://developer.teradata.com/blog/tomnolan/2012/03/jdbc-resultset-pagination

Duri83 16 posts Joined 01/12

20 Mar 2012

Thanks for explanation ^_^

You must sign in to leave a comment.