Class SqlWindowingPagingQueryProvider
java.lang.Object
org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
org.springframework.batch.item.database.support.SqlWindowingPagingQueryProvider
- All Implemented Interfaces:
PagingQueryProvider
- Direct Known Subclasses:
Db2PagingQueryProvider
,DerbyPagingQueryProvider
,SqlServerPagingQueryProvider
,SybasePagingQueryProvider
Generic Paging Query Provider using standard SQL:2003 windowing functions.
These features are supported by DB2, Oracle, SQL Server 2005, Sybase and
Apache Derby version 10.4.1.3
- Since:
- 2.0
- Author:
- Thomas Risberg, Michael Minella
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected Object
generateFirstPageQuery
(int pageSize) Method generating the query string to be used for retrieving the first page.generateJumpToItemQuery
(int itemIndex, int pageSize) Method generating the query string to be used for jumping to a specific item position.generateRemainingPagesQuery
(int pageSize) Method generating the query string to be used for retrieving the pages following the first page.protected String
protected String
protected String
protected String
protected Object
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
-
Constructor Details
-
SqlWindowingPagingQueryProvider
public SqlWindowingPagingQueryProvider()
-
-
Method Details
-
generateFirstPageQuery
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 interfacePagingQueryProvider
- Specified by:
generateFirstPageQuery
in classAbstractSqlPagingQueryProvider
- Parameters:
pageSize
- number of rows to read per page- Returns:
- query string
-
getOrderedQueryAlias
-
getSubQueryAlias
-
extractTableAlias
-
generateRemainingPagesQuery
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 interfacePagingQueryProvider
- Specified by:
generateRemainingPagesQuery
in classAbstractSqlPagingQueryProvider
- Parameters:
pageSize
- number of rows to read per page- Returns:
- query string
-
generateJumpToItemQuery
Description copied from class:AbstractSqlPagingQueryProvider
Method generating the query string to be used for jumping to a specific item position. This method must be implemented in sub classes.- Specified by:
generateJumpToItemQuery
in interfacePagingQueryProvider
- Specified by:
generateJumpToItemQuery
in classAbstractSqlPagingQueryProvider
- Parameters:
itemIndex
- the index of the item to jump topageSize
- number of rows to read per page- Returns:
- query string
-
getOverClause
-
getOverSubstituteClauseStart
-
getOverSubstituteClauseEnd
-