File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Exhausted Resultset exception when result count is huge. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exhausted Resultset exception when result count is huge." Watch "Exhausted Resultset exception when result count is huge." New topic
Author

Exhausted Resultset exception when result count is huge.

Arun Prasath
Ranch Hand

Joined: Sep 17, 2003
Posts: 192
Hi all,

I have a sql query run with two date ranges taken as parameter. The query is fine when the date range is small. But when date range is more, I am getting "Exhausted Resultset" exception.

We are using: weblogic 6.1, oracle 8i, oracle driver (classes 12.zip). There is no problem with server's disk space availability.

I am really wondering why this error comes. As I am not accessing the values when the resultset is closed.

any help or suggestions would really be of great help.
thanks in advance
s.arun prasath


SCJP 1.4, SCDJWS , SCJA<br />I can do ALL things through CHRIST who strengthens me.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
is millions of record there?
Arun Prasath
Ranch Hand

Joined: Sep 17, 2003
Posts: 192
Originally posted by adeel ansari:
is millions of record there?


Yes.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
why gettin all once.
it will slow down your performance mate.

tip: distribute the records. and get some no of records per trip.
[ November 05, 2004: Message edited by: adeel ansari ]
Arun Prasath
Ranch Hand

Joined: Sep 17, 2003
Posts: 192
thanks ansari,

do we get the exception Exhausted ResultSet when number of records in resultset is huge? I havent seen anybody facing such a issue.
nilesh Katakkar
Ranch Hand

Joined: Oct 27, 2004
Posts: 35
May be SQLTimeOut set in weblogic is expiring before you retrieve the huge resultset on the middle tier. Just a wild guess

But yeah.. makes sense to reduce the # of recrods to meaningful value if it's web app.


nilesh<br />neilindallas@hotmail.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exhausted Resultset exception when result count is huge.