Unable to Iterate over large number of records
Please take some time out and give your thoughts on the following use case.
There are 300000 records in the database table.
But when I query this table for all records I get 99999 records only.
Seems there is limitation on number of records that can be fetched from result set. Is it related to driver restriction?
Even I tried using Statement.setMaxRows(300000) but that didn’t worked out.
And it continued to fetch 99999 records only.
Is anyone aware of any such issues/limitations and is there any solution?
Please share your ideas.