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
-
Method Summary
Modifier and TypeMethodDescriptionprotected Object
generateFirstPageQuery
(int pageSize) Method generating the query string to be used for retrieving the first page.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
-
getOverClause
-
getOverSubstituteClauseStart
-
getOverSubstituteClauseEnd
-