• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Cursor State Error

 
Nishant Vashisth
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guy i am trying to make a online test website on jsp and am using a servelet to handle the result but when i execute the code it shows a invalid cursor error and i seriously don't know what the hell is wrong help me out please !!!


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbcdbc:mydata");
ResultSet rs;
PreparedStatement pst;
score=0;

for(int i=1;i<=num;i++)
{
ansgiven=request.getParameter(Integer.toString(i));
statement="select * from test where qnum = "+i ;
out.print(statement) ;
pst=con.prepareStatement(statement);
rs=pst.executeQuery();
ans=rs.getString("answer");
if(ans.equals(ansgiven))
{
score++;
}




}



The error is in this code only !!!
help me out please
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Nishant,

You should move your cursor to the first record, then another and then another



Regards,
Fatih.
 
Nishant Vashisth
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i thought of that dude !!
but i want to check the result of the question as per their numbers so that i could keep track of which question is answered correct !!
can you help me with the full code !!
 
Nishant Vashisth
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i got it working thanks for the suggestion dude !!

moderators please close this topic !!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic