Package org.springframework.batch.item.database.support

Class OraclePagingQueryProvider

java.lang.Object

org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider

org.springframework.batch.item.database.support.OraclePagingQueryProvider

All Implemented Interfaces:

PagingQueryProvider

public class OraclePagingQueryProvider
extends AbstractSqlPagingQueryProvider

Oracle implementation of a PagingQueryProvider using database specific features.

Since:

2.0

Author:

Thomas Risberg, Michael Minella

Constructor Summary

Constructors

Constructor	Description
OraclePagingQueryProvider()

Method Summary

Modifier and Type	Method	Description
String	generateFirstPageQuery(int pageSize)	Method generating the query string to be used for retrieving the first page.
String	generateRemainingPagesQuery(int pageSize)	Method generating the query string to be used for retrieving the pages following the first page.

Methods inherited from class org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider

getFromClause, getGroupClause, getParameterCount, getSelectClause, getSortKeyPlaceHolder, getSortKeys, getSortKeysWithoutAliases, getWhereClause, init, isUsingNamedParameters, setFromClause, setGroupClause, setSelectClause, setSortKeys, setWhereClause

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

OraclePagingQueryProvider

public OraclePagingQueryProvider()

Method Details

generateFirstPageQuery

public String generateFirstPageQuery(int pageSize)

Description copied from class: AbstractSqlPagingQueryProvider

Method generating the query string to be used for retrieving the first page. This method must be implemented in sub classes.

Specified by:

generateFirstPageQuery in interface PagingQueryProvider

Specified by:

generateFirstPageQuery in class AbstractSqlPagingQueryProvider

Parameters:

pageSize - number of rows to read per page

Returns:

query string

generateRemainingPagesQuery

public String generateRemainingPagesQuery(int pageSize)

Description copied from class: AbstractSqlPagingQueryProvider

Method generating the query string to be used for retrieving the pages following the first page. This method must be implemented in sub classes.

Specified by:

generateRemainingPagesQuery in interface PagingQueryProvider

Specified by:

generateRemainingPagesQuery in class AbstractSqlPagingQueryProvider

Parameters:

pageSize - number of rows to read per page

Returns:

query string