Sep 13th, 2007, 06:51 AM
How to make transactional import with spring batch
I am trying to implement the import module of our project using spring batch with the samples provided. I have 5 text files carrying the data to be written to the 5 tables of the database. If any error occurs during one of the import processes of the 5 files i have to rollback the data in all the tables.
For this purpose, i defined a job consisting of 5 simple steps(single step for each file import) I managed to make all the insertions transactional within a step by setting "commitInterval" property of simple step to a large value. However i need to make it transactional within the whole job. Is there a way of doing that in spring batch?
I tried to define a job consisting of a single step which has a CompositeItemProcessor in it.However, it didnt work either.
Any help or idea will be appreciated.
Thanks in advance,