File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error - exhausted result set

 
Tracy Zoller
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm getting an error message that I have exhausted my resultset, how do I get around this? I'm trying to first search for an applicant by ssn, then display the applicant's info which is no problem but then I want to be able to go to a new page to edit the applicant's data and I get error 'exhausted result set'? Can anyone help?
 
Bosun Bello
Ranch Hand
Posts: 1510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might want to close the resultset since you are done with it. You can edit/make updates to teh data and then make an update to the DB.
 
Cory Wilkerson
Ranch Hand
Posts: 84
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tracy,
My guess is that you've got a reference to a forward-only ResultSet (ResultSets can be acquired in many different flavors) and you've "exhausted" the ResultSet by scrolling to the end of the thing using your normal, iterative construct:

I'm now assuming you have a reference to that same ResultSet object on your next page and you're either trying to iterate to the record for updating purposes or, attempting to modify a record although your cursor has reached the end of the ResultSet.
Just something to look at...but I'm fairly sure you're attempting to scroll through a ResultSet that you've already burned through.
 
Arun Prasad Namasivayam
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
tracy,
This error is coming because ur query didnt retrieve any values,its empty, then only the error Exhausted ResultSet error will come.
arun
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic