DB Item Writer Exceptions

[frank12345]

Hello,

I am trying to write a simple batch job that reads from a flat file and writes the data to database tables. I have the job running properly when everything goes smoothly.

My issue is that if I get an exception writing a single record, such as a duplicate record, to a database the entire job fails. Can anyone tell me how to log failed record and continue processing the remaining data from the file?

Thanks,
Frank

[Dave Syer]

Did you see the sections in the user guide on skip and retry (http://static.springsource.org/sprin...onfiguringSkip, http://static.springsource.org/sprin...l#retryLogic)?

[bwawok]

I would write an aspect to take the entire list of records with the problem, and try to insert them 1 by 1 until you get to the bad record. Then either throw out that 1 record, or handle it in some way.