1 Reply Latest reply on Dec 13, 2015 2:07 AM by 2609587

    ODI 12.2.1: Excel technology - getting java.lang.IllegalArgumentException: Could not load JDBC driver class [sun.jdbc.odbc.JdbcOdbcDriver]

    jkoradba

      I upgraded to to 12.2.1. and I am unable to test successfully Excel access via ODBC.  This was working fine under 12.1.3.  Anyone experiencing this issue and perhaps has a workaround?

       

      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.<init>(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