java - Resultset.next() is not moving ahead after fetching 2.14B records out of 2.5B records and exists out after long time

Question

I'm fetching records from Oracle 12c using JDBC driver. I have total 2.5B records. After successfully fetching 2.14B records (2147483000), rs.next() got stuck and is not moving ahead and times out after a long time. I'm fetching this data from a simple hash partitioned table with 2000+ child partitions having a single NUMBER data typed column. Also, I do have sufficient memory on my machine.

Suggestions/ideas anyone?

question from:https://stackoverflow.com/questions/65661695/resultset-next-is-not-moving-ahead-after-fetching-2-14b-records-out-of-2-5b-re

Answer 1

Here I found the answer,

I was using ojdbc7 driver and resultset has a limitation of fetching records count of Integer.MAX_VALUE i.e. 2147483647

After updating ojdbc7 to ojdbc8, the issue got resolved and it successfully fetched the rest of the records.