Class SqlServerPagingQueryProvider
java.lang.Object
org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
org.springframework.batch.item.database.support.SqlWindowingPagingQueryProvider
org.springframework.batch.item.database.support.SqlServerPagingQueryProvider
- All Implemented Interfaces:
PagingQueryProvider
SQL Server implementation of a
PagingQueryProvider
using database
specific features.- Since:
- 2.0
- Author:
- Thomas Risberg, Michael Minella
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptiongenerateFirstPageQuery
(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 Object
Methods inherited from class org.springframework.batch.item.database.support.SqlWindowingPagingQueryProvider
extractTableAlias, generateJumpToItemQuery, getOrderedQueryAlias, getOverClause, getOverSubstituteClauseEnd, getOverSubstituteClauseStart
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
-
SqlServerPagingQueryProvider
public SqlServerPagingQueryProvider()
-
-
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
- Overrides:
generateFirstPageQuery
in classSqlWindowingPagingQueryProvider
- Parameters:
pageSize
- number of rows to read per page- Returns:
- query string
-
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
- Overrides:
generateRemainingPagesQuery
in classSqlWindowingPagingQueryProvider
- Parameters:
pageSize
- number of rows to read per page- Returns:
- query string
-
getSubQueryAlias
- Overrides:
getSubQueryAlias
in classSqlWindowingPagingQueryProvider
-