WebSphere Application Server Network Deployment, Version 6.1
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

JDBC mediator paging

Use paging to move easily through large data sets by limiting the amount of data from a DataGraph that is pulled into memory. The API for the JDBC data mediator service (DMS) provides two interfaces that you can use to implement paging.

New feature: Version 6.1.0.15 of the application server supports paging with both types of queries. You can supply queries for paging, or you can page queries that are generated by the JDBC mediator.newfeat

The DMS limits the size of the DataGraph based on the page size. For example, if the paging size is ten and you supply metadata that defines customers, the DMS creates the first page of the DataGraph with the first ten customer DataObjects. The next page contains the next ten customers in another DataGraph, and the next page is another DataGraph with the next ten customers. The DMS will continue to create DataGraphs until the all of the paged DataObjects have been used.

The DMS for JDBC provides paging at the root of the graph, so there is no restriction to the number of related DataObjects that can be returned. For example, if you provide metadata to the DMS that defines customers and related orders, the customers are the metadata that is paged. If the page size is set to ten, then the first page is a graph with the first ten customers and all of the orders that are related for each customer.

The DMS provides two interfaces that you can use:



Related concepts
Java DataBase Connectivity Mediator Service
Related reference
Reference topic    

Terms of Use | Feedback

Last updated: Feb 25, 2009 9:32:38 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/rdat_sdopage.html