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.
The Oracle Data Integrator (ODI) reverse engineering of PostgreSQL appears to return multiple datatype definitions of heterogeneous quality:
- Tables and views as datatypes...
- 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".
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|
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