Transaction Rollback in Spring Batch

[adish1234]

I have a Batch Program which read from different tables and Insert/update to 5 tables as per the business logic. I am using Spring JDBC for that. I want my whole trasaction should be rollback if some error happen in between but my batch program is not rolling back the previous transaction.

Please help....

Thanks

[KevinF]

Hi,

I haved the same problem. i posted a similary question last week.

Look the post below :

http://forum.springframework.org/showthread.php?t=67736

In fact, in the post Dave Syer say :

make sure you use the same DataSource in your ItemWriter as the JobRepository

[adish1234]

Thanks.
I have used JobRepository as Mysql and my application is in DB2. is there any other way i can do that..

[Dave Syer]

Read this Javaworld article http://www.javaworld.com/javaworld/j...nsactions.html and see about the options there. In your case Spring Batch is the system of record, so to be be reliable, the business transactions either have to be idemptotent or you have to use JTA.