Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

clobResultSet.next() throws error

 
achana chan
Ranch Hand
Posts: 277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All.
My servlet grabs whatever is stored in the Oracle CLOB and write it to a target file. Mostly, this is a relatively small text file.
However when I run it, clonResultSet.next() throws this error :
java.sql.SQLexception : Exhausted Resultset.
This is odd because there is definitely textual data in the CLOB.
The same servlet takes whatever is in the BLOB field (e.g. MS Word document) and stream it to a target directory. This works well !?!
Can someone give me a hint where I might have gone wrong with the CLOB ???
THX
 
Pedro Garcia
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a general error not only for CLOB fields...
"Exhausted Resultset."
means that you are doing next() to an resultset that have no more rows....
you resultset arrive to the end or is empty if is the first next...
 
achana chan
Ranch Hand
Posts: 277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
THX
Problem solved.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic