title: SQLException: Exhausted Resultset oracle11g
body: <p>my code is  :</p>
  
  <pre><code>        Statement testSt = null;
          ResultSet rset = null;
          String query = "select jid FROM playjdbc WHERE jid=56";
          try {
              testSt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                      ResultSet.CONCUR_UPDATABLE);
  
              if (!testSt.execute(query)) {
                  System.out.println("jid doesnt exist!");
              } else {
  
                  rset = testSt.getResultSet();
                  rset.first();
                  int jidValue = rset.getInt(1); // exception cause
                  System.out.println("jid is = " + jidValue);
  
              }
  
          }
  </code></pre>
  
  <p>rset.getInt(1) line causing this exception , but 
  when i ran same query in my database it returned data .</p>
  
  <p>stack trace :</p>
  
  <pre><code>java.sql.SQLException: Exhausted Resultset
      at oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:623)
      at oracle.jdbc.driver.ScrollableResultSet.getInt(ScrollableResultSet.java:776)
      at oracle.jdbc.driver.UpdatableResultSet.getInt(UpdatableResultSet.java:666)
  </code></pre>