My Oracle Support Banner

Compatibility Matrix for Java Machines and JDBC Drivers Used with ODI (Doc ID 807235.1)

Last updated on MARCH 12, 2024

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Purpose

With which versions of the Java Virtual Machine (JRE, SDK) are Oracle Data Integrator (ODI) components compatible?

Likewise, with which versions of the JVM (SDK) are ODI Metadata Navigator and ODI Lightweight Designer compatible?

Scope

Oracle Data Integrator (ODI) is a product which relies on Java, and JDBC drivers for connecting to a database.

Several versions of ODI are available, each of them having its own requirements in terms of JVM:

 Version of ODI  Required version of Java
ODI 12.2.x JDK 1.8 (1)
ODI 12.1.x JDK 1.7 (1)
ODI 11.1.1.9 JDK 1.6 and JDK 1.7 (1)
ODI 11g up to 11.1.1.7 JDK 1.6 (1)
ODI 10g JRE or JDK 1.5 (1) (2)
Sunopsis v4 JRE or JDK 1.4 (1)
Sunopsis v3 JRE or JDK 1.3 (1)

(1) For a deeper insight, consult Document 424527.1 - Certification Matrices for ODI 10g, 11g and 12c (Platform, Java, and Database Compatibilities

(2) The ODI 10g GUI components require a JVM 1.5, but ODI Agent runs with JVM 1.4, 1.5 and 1.6. Be aware that:

In addition, a JDBC driver might also have its own JVM requirements.

Thus, incompatibilities between the JVM version and the JDBC driver version may be observed.

The goal of this document is to draw a compatibility matrix for these dependencies in order to facilitate the choice of JVM (JRE, JDK) and JDBC drivers for ODI deployments.

Details

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
Purpose
Scope
Details
 Start with the JDBC driver
 Common error messages and symptoms
 Compatibility Matrix for Java Machines and JDBC Drivers Used with ODI
 iNet JDBC driver
 Microsoft SQL Server 2000 JDBC driver
 Microsoft SQL Server 2005 JDBC driver
 Microsoft SQL Server JDBC driver
 Oracle JDBC driver
 Oracle® Fusion Middleware Type 4 JDBC drivers
 Sybase/SAP, ASE, ASA and IQ JDBC driver
 Toolbox and JTOpen JDBC drivers
References

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