title: Records omitted from query using JPAPagingitemReader
body: <p>In our project, we are dumping all the data which is required for batch processing in a temperory table in the first step. In the second step, we are reading data from the temperory table, processing it(processor) and deleting it from the same temp table(in JPAWriter). We are using JPAPagingItemReader and we face the same issue as many rows are getting skipped.
  The solution given in the link (i,e using JDBCPagingItemReader) is worked for me</p>
  
  <p><a href="https://stackoverflow.com/questions/26509971/spring-batch-jpapagingitemreader-why-some-rows-are-not-read">Spring batch jpaPagingItemReader why some rows are not read?</a> </p>
  
  <p>I have few questions here, </p>
  
  <ol>
  <li>Is it a right way to use JDBCPagingItemReader along with JPAPagingWriter??</li>
  <li>Since a step will be executing in a transaction, Will it be problem if there a failure during processing/writing like rollback?</li>
  <li>Any issue with respect to performance as we need to process 1 million records?</li>
  <li>Any other approaches other than using JDBCPagingItemReader, please provide</li>
  </ol>
  
  <p>Thanks</p>