Javax.servlet.servletexception: java.sql.sqlexception: exhausted resultset

See more:

JSP

while updating data i'm facing exhausted resultset in page i retrieve two different data for first part For Login Credentials Approve working properly but For Task Approve part when i'm clicking update it is giving me Exhausted Resultset not understanding why this error showing

What I have tried:

<% Connection connect=null;
        Statement s=null;
        String employee_id=request.getParameter("id");

              Class.forName("oracle.jdbc.driver.OracleDriver");
          connect=DriverManager.getConnection("jdbc:oracle:thin:@172.18.114.213:1821:godb","xe","se");
         s=connect.createStatement();
         String sql="select * from REGISTRATION_EMPLOYEE where employee_id='"+employee_id+"' and approve='NO'";
         ResultSet rec=s.executeQuery(sql);
         if(rec!=null)
         {
             rec.next();
        %>

        <form name="frmupdate_employeeVendorLoginCredentials" method="post" action="update_process_employeeVendorLoginCredentials.jsp?employee_id=<%=rec.getString("employee_id")%>">
            <table border="1" align="center" background="images\blue-wallpaper-7.jpg">

                 <tr>
                    <th><div align="left">EMPLOYEE_ID</div></th>
                    <td><%=rec.getString("EMPLOYEE_ID")%></td>
                </tr>

                <tr>
                    <th><div align="left">FIRST_NAME</div></th>
                    <td><%=rec.getString("FIRST_NAME")%></td>
                </tr>

                 <tr>
                    <th><div align="left">LAST_NAME</div></th>
                    <td><%=rec.getString("LAST_NAME")%></td>
                </tr>

                 <tr>
                    <th><div align="left">ORGANIZATION_NAME</div></th>
                    <td><%=rec.getString("ORGANISATION_NAME")%></td>
                </tr>

                 <tr>
                    <th><div align="left">APPROVE</div></th>
                    <td>

                 <select name="txtAPPROVE" id="select_approve" value="<%=rec.getString("APPROVE")%>">
                     <option value="Y">YES</option>
                     <option value="N" selected="selected">NO</option>
                 </select>
                    </td>
                </tr>

            </table>



                <INPUT type="submit" value="Save" name="btnsubmit" class="button button2">
        </form>
        <%
            }
%>
//2nd part start from here i'm getting error in below code
<%

        String PROJECT_ID=request.getParameter("PROJECT_ID_update");


              Class.forName("oracle.jdbc.driver.OracleDriver");
          connect=DriverManager.getConnection("jdbc:oracle:thin:@172.18.114.213:1821:godb","xe","se");
         s=connect.createStatement();
         String sql1="SELECT * FROM EMPLOYEE_TASK where employee_id='"+employee_id+"' and PROJECT_ID='"+PROJECT_ID+"'";
         ResultSet rec1=s.executeQuery(sql1);
         if(rec1!=null)
         {
             rec1.next();
             String PROJECT_ID1=rec1.getString("PROJECT_ID");
        %>
        <form method="post" action="update_process_employeeVendorLoginCredentials.jsp?employee_id=<%=rec1.getString("employee_id")%>&PROJECT_ID_update=<%=PROJECT_ID1%>">

            <table align="center" border="1" align="center" bgcolor="skyblue">
                         <tr>
                    <th><div align="left">PROJECT_NAME</div></th>
                    <td><%=rec1.getString("PROJECT_NAME")%></td>
                </tr>

                <tr>
                    <th><div align="left">HEADER</div></th>
                    <td><%=rec1.getString("HEADER")%></td>
                </tr>

                 <tr>
                    <th><div align="left">DESCRIPTION</div></th>
                    <td><%=rec1.getString("DESCRIPTION")%></td>
                </tr>

                 <tr>
                    <th><div align="left">EMPLOYEE_ID</div></th>
                    <td><%=rec1.getString("EMPLOYEE_ID")%></td>
                </tr>

                 <tr>
                    <th><div align="left">APPROVE</div></th>
                    <td>

                 <select name="txtapprovetask" id="select_approve" value="<%=rec1.getString("APPROVE")%>">
                     <option value="Approve">Approve</option>
                     <option value="Pending" selected="selected">Pending</option>
                     <option value="Reject">Reject</option>
                 </select>
                    </td>
                </tr>
                     </table>