What is the idle way of handling Spring batch's writer's failure while writing on Oracle DB?

Question

Using Spring Batch's JDBCTemplate, I am trying to write data on Oracle DB. Is there any failover mechanism which can help me to process other requests if one query fails to execute ?

Possible duplicate of [Spring Batch skip exception for ItemWriter](https://stackoverflow.com/questions/22522681/spring-batch-skip-exception-for-itemwriter) — Mahmoud Ben Hassine, May 09 '19 at 07:16
@MahmoudBenHassine: it didn't but found solution with SkipPolicy. — Ashish Goel, May 09 '19 at 11:58

score 0 · Answer 1 · answered May 10 '19 at 15:56

0

Catch the exception in your batch writer and log as bad records instead of throwing the exception. This will allow next chunk/batch to execute.

answered May 10 '19 at 15:56

Tech Guy

417
2
7
23

Well... I had earlier done that but it didn't seem elegant as a generic approach to undertake. – Ashish Goel May 13 '19 at 06:42

What is the idle way of handling Spring batch's writer's failure while writing on Oracle DB?

1 Answers1