Spring Batch - Database row locked

[jgeetha2k2]

I am using Spring Batch, my job is running in DEV environment and if i start the same job in my local, its hanging. Any idea would help on this issue.

[georgevazj]

Hi!

please, could you give us some details about the issue? Is your application showing some kind of error?

Regards,

[jgeetha2k2]

I am not getting any exception. In my batch, below are the steps

1. Reads data using FlatFileItemReader
2. In Processor, get all the data from DB compares each row with the data fetched, if its equal(using equals and hashcode in entity) returning null else, I am updating the same entity with new values
3. Writes to Database using Itemwriter

I am using Spring Boot, Spring Batch with JPARepository and C3P0 pooling

In one environment I have no issues, if I am running in DEV environment, in meanwhile if I am trying to run in my local getAllData() method is stuck, no exception for a long time. Then even if I stop the server its not working, I have to truncate table then only it works. Database is common in local and DEV. Any idea?