How to use org.springframework.batch.item.database

@Override
protected void doClose() throws Exception {
  helper.close();
  super.doClose();
}

/**
 * A query string in HQL. Either this or the {
 * {@link #setQueryProvider(HibernateQueryProvider) query provider} or the {
 * {@link #setQueryName(String) query name} should be set.
 *
 * @param queryString HQL query string
 */
public void setQueryString(String queryString) {
  helper.setQueryString(queryString);
}

/**
 * A query name for an externalized query. Either this or the {
 * {@link #setQueryString(String) query string} or the {
 * {@link #setQueryProvider(HibernateQueryProvider) query provider} should
 * be set.
 *
 * @param queryName name of a hibernate named query
 */
public void setQueryName(String queryName) {
  helper.setQueryName(queryName);
}

@Override
protected ItemReader<Foo> getItemReader() throws Exception {
  JdbcCursorItemReader<Foo> result = new JdbcCursorItemReader<>();
  result.setDataSource(getDataSource());
  result.setSql("select ID, NAME, VALUE from T_FOOS");
  result.setIgnoreWarnings(true);
  result.setVerifyCursorPosition(true);
  result.setRowMapper(new FooRowMapper());
  result.setFetchSize(10);
  result.setMaxRows(100);
  result.setQueryTimeout(1000);
  result.setSaveState(true);
  result.setDriverSupportsAbsolute(false);
  return result;
}

@Override
protected ItemReader<Foo> getItemReader() throws Exception {
  String jpqlQuery = "select f from Foo f";
  JpaPagingItemReader<Foo> reader = new JpaPagingItemReader<>();
  reader.setQueryString(jpqlQuery);
  reader.setEntityManagerFactory(entityManagerFactory);
  reader.setPageSize(3);
  reader.afterPropertiesSet();
  reader.setSaveState(true);
  return reader;
}

@Override
protected ItemReader<Foo> getItemReader() throws Exception {
  SessionFactory sessionFactory = createSessionFactory();
  String hsqlQuery = "from Foo";
  HibernateCursorItemReader<Foo> reader = new HibernateCursorItemReader<>();
  reader.setQueryString(hsqlQuery);
  reader.setSessionFactory(sessionFactory);
  reader.setUseStatelessSession(true);
  reader.setFetchSize(10);
  reader.afterPropertiesSet();
  reader.setSaveState(true);
  return reader;
}

@Override
protected ItemReader<Foo> getItemReader() throws Exception {
  StoredProcedureItemReader<Foo> result = new StoredProcedureItemReader<>();
  result.setDataSource(getDataSource());
  result.setProcedureName("read_foos");
  result.setRowMapper(new FooRowMapper());
  result.setVerifyCursorPosition(false);
  result.afterPropertiesSet();
  return result;
}

@Override
protected ItemReader<Foo> createItemReader() throws Exception {
  StoredProcedureItemReader<Foo> reader = new StoredProcedureItemReader<>();
  reader.setDataSource(dataSource);
  reader.setProcedureName("read_foos");
  reader.setRowMapper(new FooRowMapper());
  reader.setVerifyCursorPosition(false);
  return reader;
}

  @Override
  public Void doInTransaction(TransactionStatus status) {
    reader.open(ec);
    reader.close();
    return null;
  }
});

  @Override
  public Void doInTransaction(TransactionStatus status) {
    reader.open(ec);
    reader.close();
    return null;
  }
});

/**
 * The Hibernate SessionFactory to use the create a session.
 *
 * @param sessionFactory the {@link SessionFactory} to set
 */
public void setSessionFactory(SessionFactory sessionFactory) {
  helper.setSessionFactory(sessionFactory);
}

/**
 * A query provider. Either this or the {{@link #setQueryString(String)
 * query string} or the {{@link #setQueryName(String) query name} should be
 * set.
 *
 * @param queryProvider Hibernate query provider
 */
public void setQueryProvider(HibernateQueryProvider<T> queryProvider) {
  helper.setQueryProvider(queryProvider);
}

/**
 * Can be set only in uninitialized state.
 *
 * @param useStatelessSession <code>true</code> to use
 * {@link StatelessSession} <code>false</code> to use standard hibernate
 * {@link Session}
 */
public void setUseStatelessSession(boolean useStatelessSession) {
  helper.setUseStatelessSession(useStatelessSession);
}

@Override
public Connection getConnection() throws SQLException {
  synchronized (this.connectionMonitor) {
    return initConnection(null, null);
  }
}

@Override
protected ItemReader<Foo> createItemReader() throws Exception {
  JdbcCursorItemReader<Foo> result = new JdbcCursorItemReader<>();
  result.setDataSource(dataSource);
  result.setSql("select ID, NAME, VALUE from T_FOOS");
  result.setIgnoreWarnings(true);
  result.setVerifyCursorPosition(true);
  
  result.setRowMapper(new FooRowMapper());
  result.setFetchSize(10);
  result.setMaxRows(100);
  result.setQueryTimeout(1000);
  result.setSaveState(true);
  return result;
}

  @Override
  public Void doInTransaction(TransactionStatus status) {
    reader.open(ec);
    reader.close();
    return null;
  }
});

/**
 * The Hibernate SessionFactory to use the create a session.
 *
 * @param sessionFactory the {@link SessionFactory} to set
 */
public void setSessionFactory(SessionFactory sessionFactory) {
  helper.setSessionFactory(sessionFactory);
}

/**
 * A query string in HQL. Either this or the {
 * {@link #setQueryProvider(HibernateQueryProvider) query provider} or the {
 * {@link #setQueryName(String) query name} should be set.
 *
 * @param queryString HQL query string
 */
public void setQueryString(String queryString) {
  helper.setQueryString(queryString);
}

/**
 * A query name for an externalized query. Either this or the {
 * {@link #setQueryString(String) query string} or the {
 * {@link #setQueryProvider(HibernateQueryProvider) query provider} should
 * be set.
 *
 * @param queryName name of a hibernate named query
 */
public void setQueryName(String queryName) {
  helper.setQueryName(queryName);
}

/**
 * A query provider. Either this or the {{@link #setQueryString(String)
 * query string} or the {{@link #setQueryName(String) query name} should be
 * set.
 *
 * @param queryProvider Hibernate query provider
 */
public void setQueryProvider(HibernateQueryProvider<? extends T> queryProvider) {
  helper.setQueryProvider(queryProvider);
}