Spring Batch - Getting a DeadlockLoserDataAccessException when trying to read/write to the same table
0
I am working on a Spring Batch application that will Read unprocessed data from Table A, process the Data, Insert the processed Data to Table B, and then Update the row in Table A to PROCESSED. However, while Inserting the data into Table B works fine, I keep getting a DeadlockLoserDataAccessException every time I try to Updated Table A. I believe this is due to the Curser from the JDBCCursorItemReader that was used to read Table A is getting in the way of Updating the Table. How would I go about fixing this? I use a JDBCCursorItemReader and CompositeItemWriter in the Spring Batch. The chunk size is 1.
java db2 spring-batch compositeitemwriter
share | improve this question