Hello there!
I have a query that returns a large amount of data (please don't throw any rocks at me, I really have some reasons for this query although I do not agree with them). The query is very simple:
SELECT email from USERS; single column, indexed on Oracle 10g.
Problem is: 1.98 million results.
Well, running this query using a tool like SquirrelSQL (pure
java) it does run (ok, I dunno what kind of parameters it use to maybe limit the size of the query return)
But truth is, when I run this (I'm using Spring with
JDBC here), as soon as I hit: rs.next(); I get this exception.
Is there a way to avoid this? I've checked Oracle's docs and it says that it's caused because there's too many opened cursors. I'm stupid on this, but a single connection has more than one cursor?
Any ideas on how can I fetch such huge amount of data?