Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

servlets  RSS feed

 
anu manju
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
when i open the new resultset within while loop
of another resultset i met a problem that "Resultset is closed" how i can overcome this problem
 
Geeta Ramasami
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Ensure that u work with different result sets.Can u just post the code?
Regards
Geeta
 
Andy Bowes
Ranch Hand
Posts: 171
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you create a 2nd ResultSet using the same Statement instance then the previous ResultSet is automically closed.
To get around this feature use 2 Statement instances to create the 2 ResultSets that you want to iterate through.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!