My Oracle Support Banner

In ODI Integration Interfaces, when Using the Hongxin (HXTT) JDBC Driver, Only 1000 Records Are Loaded (Doc ID 453794.1)

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI), having a dBase (dbf) File which contains about 5000 records.

  1. When consulting Data from Oracle Data Integrator (ODI) Designer or Squirrel, only 1000 rows are displayed.
  2. When executing an Oracle Data Integrator (ODI) Integration Interface having this File as Source Datastore, only 1000 records are loaded

All tests above have been done with the TRIAL version of the Hongxin (HXTT) type 4 JDBC Driver for dBase.

The same behavior may be observed for any other technology (dBase, Microsoft Excel...) that uses the TRIAL version of Hongxin (HXTT) JDBC Drivers.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.