Re: java.sql.SQLException: Exhausted Resultset

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 25 May 2005 21:07:30 +0200
Message-ID: <o0j991d0mssbd06ghvl80o834pgfja1kft@4ax.com>

On Wed, 25 May 2005 18:47:46 GMT, Alessandro Lagostena <alessandro.lagostena_at_tin.it> wrote:

>Can this error depend from a bad status of the table ?

No, in that case an ORA- error message would have been thrown

>
>I check on the alert log of oracle and not found any message

Of course not, because nothing is wrong with the database. The problem is with 'scanning' 8 million records
>
>Do someone have an idea ?

Yes. Why is it that Java programmers live in the misconception they never ever make a mistake, that Java isn't memory hungry, and their programs never run out of memory?
Why is it they invariably blame the database for their mistakes? Because they don't know anything about the database and treat it as a flat file system?
Nagging questions with obvious answers.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 25 2005 - 14:07:30 CDT