title: Long running query with huge resultset using java programming
body: <p>I am looking for technical solution for one of our project requirement but could not get right approach in google. </p>
  
  <p>Below are the requirements.</p>
  
  <p>1) We have long running Oracle query, which runs approximately 1.5 hours on business hours and it returns ~10Million records.</p>
  
  <p>2) We have to insert/ dump this resultset into Sqlserver Db Table using Java programming.</p>
  
  <p>Here are my worries on this requirement. 
  It might give (Out of memory) error when retrieving all records using Sql Query. 
  It might lead to Network timeout, etc</p>
  
  <p>Planing to do with Spring batch/ kafka stream processor etc, not sure whether its achievable.
  Please suggest the java Best approaches/ Technologies to achive this with out any issues. Thanks in advance</p>