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 19, 2019

Applies to:

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

Symptoms

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!


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


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