Apr 17th, 2012, 01:55 PM
Resuming failed step that runs a batch of SQL queries
I try to accomplish the following task:
Given a txt file that contains n SQL queries (the queries do not fit the same pattern e.g. insert, delete, create statements etc) semicolon - separated.
1. process the queries.
2. in case i-th query failed be able to resume the batch from the query that failed.
I created a simple job with a single step having a FlatFileItemReader that parses the SQL queries and feeds them to the ItemWriter that delegates a single query execution to DAO.
I wonder is there any standard API for resuming the failed step that will execute the batch starting with the first query that failed in the previous run? I failed to find anything that fits the bill in the spring-batch API docs.
What would be the best approach to implement the resume operation?
I would appreciate your assistance.
Tags for this Thread