title: Invalid row number (65536) outside allowable range (0..65535)
body: <p>I am reading integers from a text file, giving them as input to a query and getting the query output and writing to an xls file.</p>
  
  <pre><code>ResultSet rs;
  Connection con = null;
  PreparedStatement ps = null;
  int person_org_id, external_person_org_id;
  File f = null;
  Scanner scan = null;
  
  try {
      System.out.println("----------checkpoint-----------");
      Class.forName("oracle.jdbc.driver.OracleDriver");
      System.out.println("----------checkpoint 1-----------");
      con = DriverManager.getConnection("jdbc:oracle:thin:@ksdjf.kjdlk.jkd.com:2222:edb", "aaaaa", "aaaa");
      System.out.println("----------checkpoint 2 ----------");
      if (con == null) {
          System.out.println("unable to connect to database");
      }
      System.out.println("----------checkpoint 3::connected to database---------");
      StringBuffer sql = new StringBuffer();
      sql.append("select abd from edb.abd where customer_id=510 and person_org_id =? ");
      ps = con.prepareStatement(sql.toString());
  
      HSSFWorkbook wb = new HSSFWorkbook();
      HSSFSheet sheet = wb.createSheet("Excel Sheet");
      HSSFRow rowhead = sheet.createRow(0);
      rowhead.createCell(0).setCellValue("ABC");
      rowhead.createCell(1).setCellValue("DEF");
  
      f = new File("/tmp/contacts.txt");
      scan = new Scanner(f);
      int index=1;
  
      while (scan.hasNextInt()) {
  
          person_org_id = scan.nextInt();
  
          ps.setInt(1,person_org_id);
          rs= ps.executeQuery();
  
          while (rs.next()) {                 
  
              external_person_org_id = rs.getInt(1);
  
              HSSFRow row = sheet.createRow(index);
              row.createCell(0).setCellValue(person_org_id);
              row.createCell(1).setCellValue(external_person_org_id);
              index++;
          }           
  
      }   
      FileOutputStream fileOut = new FileOutputStream(new File("/tmp/External_contact_id.xls"));
      wb.write(fileOut);
      fileOut.close();
      System.out.println("--------checkpoint 4:: writing data to xls completed------------");
  }
  catch (Exception e) {
      System.out.println(e.getMessage());
  }
  </code></pre>
  
  <p>I am getting error <code>Invalid row number (65536) outside allowable range (0..65535)</code> </p>
  
  <p>My <code>contacts.txt</code> file has around 36000 numbers.</p>