reader.setPreparedStatementSetter(this.preparedStatementSetter); reader.setRowMapper(this.rowMapper); reader.setSql(this.sql);
@Before public void onSetUpInTransaction() throws Exception { itemReader = new JdbcCursorItemReader<>(); itemReader.setDataSource(dataSource); itemReader.setSql("select ID, NAME, VALUE from T_FOOS where ID > ? and ID < ?"); itemReader.setIgnoreWarnings(true); itemReader.setVerifyCursorPosition(true); itemReader.setRowMapper(new FooRowMapper()); itemReader.setFetchSize(10); itemReader.setMaxRows(100); itemReader.setQueryTimeout(1000); itemReader.setSaveState(true); List<Long> parameters = new ArrayList<>(); parameters.add(1L); parameters.add(4L); ListPreparedStatementSetter pss = new ListPreparedStatementSetter(parameters); itemReader.setPreparedStatementSetter(pss); }
reader.setPreparedStatementSetter(this.preparedStatementSetter); reader.setRowMapper(this.rowMapper); reader.setSql(this.sql);