@Override
protected void pointToEmptyInput(ItemReader<Foo> tested) throws Exception {
StoredProcedureItemReader<Foo> reader = (StoredProcedureItemReader<Foo>) tested;
reader.close();
reader.setDataSource(getDataSource());
reader.setProcedureName("read_some_foos");
reader.setParameters(
new SqlParameter[] {
new SqlParameter("from_id", Types.NUMERIC),
new SqlParameter("to_id", Types.NUMERIC)
});
reader.setPreparedStatementSetter(
new PreparedStatementSetter() {
@Override
public void setValues(PreparedStatement ps)
throws SQLException {
ps.setInt(1, 1000);
ps.setInt(2, 1001);
}
});
reader.setRowMapper(new FooRowMapper());
reader.setVerifyCursorPosition(false);
reader.afterPropertiesSet();
reader.open(new ExecutionContext());
}