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

Class SqlWindowingPagingQueryProvider

java.lang.Object
org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
org.springframework.batch.item.database.support.SqlWindowingPagingQueryProvider
All Implemented Interfaces:
PagingQueryProvider
@Deprecated(forRemoval=true) public class SqlWindowingPagingQueryProvider extends AbstractSqlPagingQueryProvider
Deprecated, for removal: This API element is subject to removal in a future version.
since 5.2.1 with no replacement. Scheduled for removal in 6.0.
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 Details

    • SqlWindowingPagingQueryProvider

      public SqlWindowingPagingQueryProvider()
      Deprecated, for removal: This API element is subject to removal in a future version.

  • Method Details

    • generateFirstPageQuery

      public String generateFirstPageQuery(int pageSize)
      Deprecated, for removal: This API element is subject to removal in a future version.
      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

    • getOrderedQueryAlias

      protected String getOrderedQueryAlias()
      Deprecated, for removal: This API element is subject to removal in a future version.

    • getSubQueryAlias

      protected Object getSubQueryAlias()
      Deprecated, for removal: This API element is subject to removal in a future version.

    • extractTableAlias

      protected Object extractTableAlias()
      Deprecated, for removal: This API element is subject to removal in a future version.

    • generateRemainingPagesQuery

      public String generateRemainingPagesQuery(int pageSize)
      Deprecated, for removal: This API element is subject to removal in a future version.
      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

    • getOverClause

      protected String getOverClause()
      Deprecated, for removal: This API element is subject to removal in a future version.

    • getOverSubstituteClauseStart

      protected String getOverSubstituteClauseStart()
      Deprecated, for removal: This API element is subject to removal in a future version.

    • getOverSubstituteClauseEnd

      protected String getOverSubstituteClauseEnd()
      Deprecated, for removal: This API element is subject to removal in a future version.