Spring batch Itemwriter using Storedprocedure

Question

Can we use Stored procedure in Spring batch Itemwriter to write data or Tasklet is the only way?

Answer 1

I think you are looking something like this Invoking Stored Procedure using Spring JdbcBatchItemWriter

The answer is yes, implementing it is straightforward given the code below:

    JdbcBatchItemWriter<Person> writer = new JdbcBatchItemWriter<Person>();
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Person>());
    writer.setSql("CALL SP(:firstName, :lastName)");
    writer.setDataSource(dataSource);