My Oracle Support Banner

Reverse Engineering PostgreSQL Datatypes Returns Incorrect Results in ODI Topology Manager (Doc ID 424718.1)

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Data Integrator - Version to
Information in this document applies to any platform.


The Oracle Data Integrator (ODI) reverse engineering of PostgreSQL appears to return multiple datatype definitions of heterogeneous quality:

  1. Tables and views as datatypes...
  2. Duplicate datatypes... once normally (as expected) and once preceded by an underscore. For example, "int" would be returned twice: once as "int" and another as "_int".
PostgreSQL and its JDBC driver have been downloaded from:

            Note: Oracle is not responsible for any instructions/information/drivers obtained from 3rd party site.

The following list matches up versions of the JVM with the JDBC specification implementation to be used:

Java versionJDBC specification
JDK 1.3 JDBC 2
JDK 1.3 + J2EE JDBC 2 EE
JDK 1.4, JDK 1.5 JDBC 3



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.