CODEWITHSUNDEEP
javaoracle-databasejdbc
Chetan Lohar
Chetan Lohar

Reputation: 61

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

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?

Upvotes: 1

Views: 135

Answers (1)

Chetan Lohar
Chetan Lohar

Reputation: 61

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.

Upvotes: 2

Related Questions