My Oracle Support Banner

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

Last updated on APRIL 28, 2021

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
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.html

            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 version JDBC 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
   

 

Changes

 

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
Changes
Cause
Solution

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