i try execute code show following error:
java.sql.sqlexception.operation not allowed after resultset closed
this code.in code shows above error..
<table cellspacing="0"> <% try{ resultset rs1=st.executequery("select u.post_id,u.userid,u.post_txt requestdetails r inner join user_post u on r.frdname=u.userid r.userid='"+id+"'"); while(rs1.next()){ int post_id=rs1.getint(1); int fid=rs1.getint(2); system.out.println("iiii "+fid); string text=rs1.getstring(3); system.out.println("txttt "+text); resultset rs3=stat.executequery("select * userdetails userid='"+fid+"'"); if(rs3.next()){ string na=rs3.getstring("username"); system.out.println("username "+na); string img=rs3.getstring("profilepic"); system.out.println("imgee "+img); %> <tr> <td width="5%" style="padding-left:25;" rowspan="2"> <img src="images/<%=img%>" height="60" width="55"> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="3" style="padding:7;"><a href="" style="text-transform:capitalize; text-decoration:none; color:#003399;" onmouseover="" onmouseout="" id=""><%=rs3.getstring("username") %></a> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td></td> <td colspan="3" style="padding-left:7;"><%=text %></td> </tr> <% resultset rr=st.executequery("select * comment_status post_id='"+post_id+"'"); while(rr.next()){ int uid=rr.getint("userid"); string cmt=rr.getstring("comment"); resultset rrr=stat.executequery("select * userdetails userid='"+uid+"'"); if(rrr.next()){ %> <tr> <td> </td> <td width="4%" bgcolor="#edeff4" style="padding-left:12;" rowspan="2"> <img src="" height="40" width="47"> </td> <td bgcolor="#edeff4" style="padding-left:7;" > <a href="" style="text-transform:capitalize; text-decoration:none; color:#3b5998;" onmouseover="comment_name_underline()" onmouseout="comment_name_nounderline()" id="cuname"><%=rrr.getstring("username") %></a> </td> <td align="right" rowspan="2" bgcolor="#edeff4"> </tr> <tr> <td> </td> <td bgcolor="#edeff4" style="padding-left:7;" colspan="2"><%=cmt %></td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <% } } %> <tr> <td> </td> <td width="4%" style="padding-left:17;" bgcolor="#edeff4" rowspan="2"> <img src="images/" height="33" width="33"> </td> <td bgcolor="#edeff4" colspan="2" style="padding-top:15;"> <form method="post" name="commenting" onsubmit="return blank_comment_check()" action="commentstatus.jsp"> <input type="text" name="comment_txt" placeholder="write comment..." maxlength="420" style="width:100px;" id=""> <input type="hidden" name="postid" value="<%=post_id%>"> <input type="hidden" name="userid" value=""> <input type="submit" name="comment" style="display:none;"> </form> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="4"align="right" style="border-top:outset; border-top-width:thin;"> </td> </tr> <% } } }catch(exception e){ e.printstacktrace(); } %> </table> </div> i don't know mistake i've done in above code.
after change code this, it's working fine...
statement stt=con.createstatement(); resultset rs1=stt.executequery("select u.post_id,u.userid,u.post_txt requestdetails r inner join user_post u on r.frdname=u.userid r.userid='"+id+"'"); while(rs1.next()){ int post_id=rs1.getint(1); int fid=rs1.getint(2); system.out.println("iiii "+fid); string text=rs1.getstring(3); system.out.println("txttt "+text); statement st1=con.createstatement(); resultset rs3=st1.executequery("select * userdetails userid='"+fid+"'"); if(rs3.next()){ string na=rs3.getstring("username"); system.out.println("username "+na); string img=rs3.getstring("profilepic"); system.out.println("imgee "+img); 