Spring Batch - filetodatabase - db2 database - Non-atomic batch failure error

[nikunj_c]

Hello All,

I am a new user of Spring Batch. Trying to create a simple application which reads from a file and writes to a database table.

A batch of prepared statements (insert into queries) are getting created. But then I am getting the error:

com.ibm.db2.jcc.b.ie: Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.

1) Why am I getting this error? What could be the cause of this error?
2) How to use getNextException inside Spring Batch?

My database connections are fine, as I am using tables in the same database as Job Repository and they are working fine!!

Looking forward for any helpful advice.

Thanks and Regards,
Nik

[Dave Syer]

A stack trace would be helpful here. Not sure otherwise how we can help. Wild guess: JDBC batch failures are often a cryptic signal from ORM products that they blew up on commit. Are you using Hibernate or JPA?

[nikunj_c]

Hello Dave,

Thanks for your reply!!

It indeed was a db error..

Alteration of the table happened without any reorg!!

Could you please clear my doubt regarding skip during write... I have asked the query in other thread but not getting any help!!

Thanks,
Nikunj...