How can fetch more than 200000 records from database using PreparedStatement

[ptkumar]

Hi All,

I am facing one problem, i fetch the record from database using preparedstatement. The resultset contains morethan 300000 records. it got OutOfMemoryError.


Plz any body can help me.

[pranjalsingh]

Hi All,

I am facing one problem, i fetch the record from database using preparedstatement. The resultset contains morethan 300000 records. it got OutOfMemoryError.


Plz any body can help me.

Hi,
If u r using EJB3.0 for that, then in that we have a function to specify the records to be loaded at a time, which can solve ur problem. It means u can break the records in 10,000, then it will fetch only 10,000 records at a time, & after the execution again it will load the next 10,000. SO now u can understand that u can solve ur problem.