Announcement Announcement Module
No announcement yet.
Resuming failed step that runs a batch of SQL queries Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.