This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes clobResultSet.next() throws error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "clobResultSet.next() throws error" Watch "clobResultSet.next() throws error" New topic
Author

clobResultSet.next() throws error

achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
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


humanum errare est.
Pedro Garcia
Greenhorn

Joined: Sep 12, 2002
Posts: 15
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...


Pedro
achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
THX
Problem solved.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: clobResultSet.next() throws error
 
Similar Threads
clob.setCharacterStream(1); Unsupported feature
How to register a Clob in the dataBase
JVM Out Of Memory...How to increase Heap Size??
Problem inserting Blob into Oracle DB
Clob to String (Using Hibernate)