Jun 2nd, 2010, 08:44 AM
Database level locking in ItemWriter
I am working in Spring batch 2.1.
While performing partioning with grid size = 5 , partioning is working fine.
but when my grid size increases , data base level locking is taking place in the writer and the execution doesnt stop. We need to stop the execution manually.
It is not displaying any error or exception.
following things I tried to resolve the above issue.
1. I have increased the heap size, even then facing the same issue.
2. IsolationLevel with Isolation_read_Commited
<property name="targetDataSource" ref="targetDataSource">
3. I made the Transaction attribute as default.
<transaction-attributes propagation="REQUIRES_NEW" isolation="DEFAULT" />
What is the reason for this issue and How to solve it.?
Maximum how many grid-size can we give for partitioning.?
kindly reply at the earliest.
Thanks for your reply.