My query returns 64000 records. I am using ordinary result set object to retrieve the records. All the records are stored in to ArrayList.
After certain number of records(11000), the resultSet neither moves to next record or throws any exception. It seems to me like a weird problem. I don't know what might be the cause of the problem.
Please let me know. If you think, it might be a memory problem, then pls let me know how to increase heap memory of Oracle AS.
Oracle
JDBC Drive version: 10.1.0.3.0
Java version: 1.4.2_04
Application server: Oracle AS 10.1.2.0.2
I appreciate your help
Thanks,