Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exhausted Resultset exception when result count is huge.

 
Arun Prasath
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is millions of record there?
 
Arun Prasath
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by adeel ansari:
is millions of record there?


Yes.
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic