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 aPagingQueryProviderusing database specific features.- Since:
- 2.0
- Author:
- Thomas Risberg, Michael Minella
Constructor Summary
Constructors Constructor Description OraclePagingQueryProvider()
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description java.lang.StringgenerateFirstPageQuery(int pageSize)Method generating the query string to be used for retrieving the first page.java.lang.StringgenerateJumpToItemQuery(int itemIndex, int pageSize)Method generating the query string to be used for jumping to a specific item position.java.lang.StringgenerateRemainingPagesQuery(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
Method Detail
generateFirstPageQuery
public java.lang.String generateFirstPageQuery(int pageSize)
Description copied from class:AbstractSqlPagingQueryProviderMethod generating the query string to be used for retrieving the first page. This method must be implemented in sub classes.- Specified by:
generateFirstPageQueryin interfacePagingQueryProvider- Specified by:
generateFirstPageQueryin classAbstractSqlPagingQueryProvider- Parameters:
pageSize- number of rows to read per page- Returns:
- query string
generateRemainingPagesQuery
public java.lang.String generateRemainingPagesQuery(int pageSize)
Description copied from class:AbstractSqlPagingQueryProviderMethod 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:
generateRemainingPagesQueryin interfacePagingQueryProvider- Specified by:
generateRemainingPagesQueryin classAbstractSqlPagingQueryProvider- Parameters:
pageSize- number of rows to read per page- Returns:
- query string
generateJumpToItemQuery
public java.lang.String generateJumpToItemQuery(int itemIndex, int pageSize)Description copied from class:AbstractSqlPagingQueryProviderMethod generating the query string to be used for jumping to a specific item position. This method must be implemented in sub classes.- Specified by:
generateJumpToItemQueryin interfacePagingQueryProvider- Specified by:
generateJumpToItemQueryin classAbstractSqlPagingQueryProvider- Parameters:
itemIndex- the index of the item to jump topageSize- number of rows to read per page- Returns:
- query string