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 3.2.03.01 to 10.1.3.9.99
Information in this document applies to any platform.

Symptoms

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: https://jdbc.postgresql.org/download/

            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
JDK 1.6 JDBC4
   

 

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.