File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

clobResultSet.next() throws error

 
achana chan
Ranch Hand
Posts: 277
  • 0
  • 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
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
THX
Problem solved.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic