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 OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version and later
Generic (Platform Independent)
This problem can occur on any platform.


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.


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

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

In this Document
 Solution 1: Use the ODBC JDBC Bridge
 Solution 2: Purchase the Hongxin JDBC Driver

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