TransactionTemplate tt = new TransactionTemplate(tm); final StoredProcedureItemReader<String> reader = new StoredProcedureItemReader<>(); reader.setDataSource(ds); reader.setProcedureName("foo_bar"); final ExecutionContext ec = new ExecutionContext();
TransactionTemplate tt = new TransactionTemplate(tm); final StoredProcedureItemReader<String> reader = new StoredProcedureItemReader<>(); reader.setDataSource(new ExtendedConnectionDataSourceProxy(ds)); reader.setUseSharedExtendedConnection(true); reader.setProcedureName("foo_bar");
TransactionTemplate tt = new TransactionTemplate(tm); final StoredProcedureItemReader<String> reader = new StoredProcedureItemReader<>(); reader.setDataSource(ds); reader.setProcedureName("foo_bar"); reader.setParameters(new SqlParameter[] {
itemReader.setRefCursorPosition(this.refCursorPosition); itemReader.setCurrentItemCount(this.currentItemCount); itemReader.setDataSource(this.dataSource); itemReader.setDriverSupportsAbsolute(this.driverSupportsAbsolute); itemReader.setFetchSize(this.fetchSize);
@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 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 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()); }
itemReader.setRefCursorPosition(this.refCursorPosition); itemReader.setCurrentItemCount(this.currentItemCount); itemReader.setDataSource(this.dataSource); itemReader.setDriverSupportsAbsolute(this.driverSupportsAbsolute); itemReader.setFetchSize(this.fetchSize);