title: Java SQL ResultSet Exception
body: <p>I'm Developing a Web Application using JSF &amp; PrimeFaces. I have two classes Inputs &amp; DBConn. And i'm executing a SQL command like this</p>
  
  <pre><code>SQL="SELECT COUNT(*) FROM TXN_HEADER WHERE REQUEST_DATE='01-AUG-2014'"
  </code></pre>
  
  <p>And then in the <strong>DBConn class</strong> i call the <strong>next()</strong> method on the <strong>ResultSet object</strong> inside a while loop condition to print the result.</p>
  
  <p>This works fine and gives me an output.</p>
  
  <p>But when i try to call that <strong>ResultSet object</strong> to get an output using the same scenario above (using that while loop inside the <strong>Inputs class</strong>) it gives me the following exception.</p>
  
  <pre><code>java.sql.SQLException: Result set after last row
  at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:879)
  at Inputs.commandButton(Inputs.java:41)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.apache.el.parser.AstValue.invoke(AstValue.java:245)
  at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:277)
  at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
  at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
  at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
  at javax.faces.component.UICommand.broadcast(UICommand.java:315)
  at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)
  at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)
  at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
  at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
  at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198)
  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:646)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655)
  at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Unknown Source)
  </code></pre>
  
  <p>Then i assumed that after the first use of the <strong>next()</strong> method the cursor is still in the end though i used the <strong>next()</strong> method again in that <strong>Inputs class</strong>. </p>
  
  <p>So i tried using the <strong>.beforeFirst()</strong> method before going to the 2nd while loop to reset the cursor back to the top. But it gave me the same error again.</p>
  
  <p>Then i tried commenting the 1st while loop i access in the <strong>DBConn class</strong> so the cursor is at the top for sure. But then it gives me the following error.</p>
  
  <pre><code>java.sql.SQLException: ResultSet.next was not called
  at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:874)
  at Inputs.commandButton(Inputs.java:41)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.apache.el.parser.AstValue.invoke(AstValue.java:245)
  at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:277)
  at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
  at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
  at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
  at javax.faces.component.UICommand.broadcast(UICommand.java:315)
  at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)
  at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)
  at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
  at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
  at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198)
  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:646)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655)
  at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Unknown Source)
  </code></pre>
  
  <p>How do i resolve this? This is my first time developing a Database Application.
  And sorry about these bunch of sys.prints, I used them for debugging.</p>
  
  <p>These are the two classes related to this case:</p>
  
  <p><strong>Inputs Class</strong></p>
  
  <pre><code>import java.sql.SQLException;
  
  import javax.annotation.ManagedBean;
  
  @ManagedBean
  public class Inputs {
  private String date;
  private String showRes;
  
  public String getDate() {
      return date;    
  }
  
  public void setDate(String date) {
      this.date = date;
  }
  
  public String getShowRes() {
      return showRes;
  }
  
  public void setShowRes(String showRes) {
      this.showRes=showRes;
  }
  
  public void commandButton(){
  
      DBConn nCon=new DBConn();
  
      Calculations nCalc=new Calculations();
      nCalc.setPieChartSQL(getDate());
      nCon.setSQL(nCalc.getPieChartSQL());
  
      System.out.println("............");
      System.out.println(nCon.getResultSet());
      System.out.println("............");
      System.out.println(nCon.getResultSet());
      System.out.println("............");
  
      try {
          System.out.println(nCon.getResultSet().getString(1));
          //nCon.getResultSet().beforeFirst();
          while(nCon.getResultSet().next()){
              System.out.println("++++++++++++");
              System.out.println(nCon.getResultSet().getString(1));
              System.out.println("++++++++++++");
              setShowRes(nCon.getResultSet().getString(1));
          }
      } catch (SQLException e) {
          e.printStackTrace();
      }
      System.out.println("777777777777777777777");
  }
  
  }
  </code></pre>
  
  <p><strong>DBConn Class</strong></p>
  
  <pre><code>import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  
  import oracle.jdbc.OracleConnection;
  import oracle.jdbc.pool.OracleDataSource;
  
  public class DBConn {
  
  private String sql;
  private ResultSet rs;
  
  public ResultSet getResultSet(){
  
      try {
          OracleDataSource dataSource=new OracleDataSource();
          dataSource.setURL("jdbc:oracle:thin:@172.16.20.45:1521:ABS");
          dataSource.setUser("&lt;user&gt;");
          dataSource.setPassword("&lt;pass&gt;");
  
          OracleConnection con = (OracleConnection)dataSource.getConnection();
          con.setAutoCommit(false);
  
          Statement stmnt = con.createStatement();
          rs = stmnt.executeQuery(sql);
          System.out.println("-----------");
          System.out.println(rs);
          System.out.println("-----------");
          System.out.println(rs);
          System.out.println("-----------");
  
          while(rs.next()){
              System.out.println("*************");
              System.out.println(rs.getString(1));
              System.out.println("*************");
          }
  
  
      } catch (SQLException e) {
          e.printStackTrace();
      }
  
      return rs;
  }
  
  public void setSQL(String sql) {
      this.sql=sql;
  }
  
  }
  </code></pre>