reset password
Author Message
milincjoshi
Posts: 7
Posted 21:10 Nov 15, 2015 |

  Statement getData = conn.createStatement();
  result = getData.executeQuery(statement);
  getData.close();
     

 while(result.next()){
     System.out.println(result.getString("Email"));
            }

ResultSet in neither closed nor the same statement in used twice. Still there's and SQL Exception that Operation not allowed after ResultSet closed

dhaval0704
Posts: 14
Posted 21:15 Nov 15, 2015 |

Try getData.close()  after while loop then error will be solved.

milincjoshi
Posts: 7
Posted 21:46 Nov 15, 2015 |

Same Thing. No effect.