org.springframework.batch.item.database.support
Class H2PagingQueryProvider

java.lang.Object
  org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
      org.springframework.batch.item.database.support.H2PagingQueryProvider

All Implemented Interfaces:

PagingQueryProvider

public class H2PagingQueryProvider
extends AbstractSqlPagingQueryProvider

H2 implementation of a PagingQueryProvider using database specific features.

Since:

2.1

Author:

Dave Syer

Constructor Summary

H2PagingQueryProvider()

Method Summary

String	generateFirstPageQuery(int pageSize) Method generating the query string to be used for retrieving the first page.
String	generateJumpToItemQuery(int itemIndex, int pageSize) Method generating the query string to be used for jumping to a specific item position.
String	generateRemainingPagesQuery(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, getParameterCount, getSelectClause, getSortKey, getSortKeyPlaceHolder, getSortKeyWithoutAlias, getWhereClause, init, isAscending, isUsingNamedParameters, setAscending, setFromClause, setSelectClause, setSortKey, setWhereClause

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

H2PagingQueryProvider

public H2PagingQueryProvider()

Method Detail

generateFirstPageQuery

public String generateFirstPageQuery(int pageSize)

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

generateRemainingPagesQuery

public String generateRemainingPagesQuery(int pageSize)

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

generateJumpToItemQuery

public String generateJumpToItemQuery(int itemIndex,
                                      int pageSize)

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 interface PagingQueryProvider

Specified by:

generateJumpToItemQuery in class AbstractSqlPagingQueryProvider

Parameters:

itemIndex - the index of the item to jump to

pageSize - number of rows to read per page

Returns:

query string