'java.lang.IllegalArgumentException: Could not load JDBC driver class [xxxx]' Messages Signaled When Testing Connections To ODI 12c Data Servers Or Running Scenarios (Doc ID 1614497.1)

Last updated on AUGUST 12, 2017

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, when either

... messages such as the following are signaled:

oracle.odi.runtime.agent.invocation.InvocationException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:330)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:890)

    or

java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [org.postgresql.Driver]
  at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:106)
  at oracle.odi.core.DataSourceManager$LoginTimeoutDataSourceProviderProxy.configure(DataSourceManager.java:304)

Cause

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 hundreds of Community platforms