“ODI-26039: Connection failed” Error Received While Connecting to Excel File via ODI 12.2.1 with JDK 8 (Doc ID 2092734.1)

Last updated on AUGUST 14, 2017

Applies to:

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

Symptoms

The following error is receive while testing the connection to a Microsoft Excel file using ODI 12.2.1 with JDK 8:

ODI-26039: Connection failed
java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [sun.jdbc.odbc.JdbcOdbcDriver]
   at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:106)
  at oracle.odi.core.DataSourceManager$LoginTimeoutDataSourceProviderProxy.configure(DataSourceManager.java:305)
  at oracle.odi.core.DataSourceManager.createAndConfigureDataSourceProvider(DataSourceManager.java:231)
  at oracle.odi.core.DataSourceManager.access$000(DataSourceManager.java:57)
  at oracle.odi.core.DataSourceManager$1.create(DataSourceManager.java:76)
  at org.springframework.util.CachingMapDecorator.get(CachingMapDecorator.java:152)
  at java.util.Collections$SynchronizedMap.get(Collections.java:2584)
  at oracle.odi.core.DataSourceManager.getDataSource(DataSourceManager.java:154)
  at oracle.odi.core.OdiInstance.lookupDataSource(OdiInstance.java:1151)
  at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.getDataSourceAdapter(DwgConnectConnectionCreatorImpl.java:127)
  at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:111)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:200)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1100(SnpsDialogTestConnet.java:62)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:400)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:396)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
  at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Could not load JDBC driver class [sun.jdbc.odbc.JdbcOdbcDriver]
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:178)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.(DriverManagerDataSource.java:110)
  at oracle.odi.core.datasource.provider.DriverManagerDataSourceProvider.doCreateDataSource(DriverManagerDataSourceProvider.java:36)
  at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:97)
  ... 17 more

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