File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes throws error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark " throws error" Watch " throws error" New topic
Author 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, 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 ???

humanum errare est.
Pedro Garcia

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...

achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
Problem solved.
I agree. Here's the link:
subject: throws error
It's not a secret anymore!