reader.setQueryTimeout(this.queryTimeout); reader.setUseSharedExtendedConnection(this.useSharedExtendedConnection); reader.setVerifyCursorPosition(this.verifyCursorPosition);
@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); }
@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 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; }
reader.setQueryTimeout(this.queryTimeout); reader.setUseSharedExtendedConnection(this.useSharedExtendedConnection); reader.setVerifyCursorPosition(this.verifyCursorPosition);