Analytics Software

Hello,


network environment:
source DB --> UBUNT Server --> MySQL DB
target DB --> Ms Windows 2008 Server --> Oracle 11g Database

software :
Oracle ODI Studio 11.1.5.
mysql-connector-java-5.1.18-bin


problem:
I copy the jar file into the folder +<ODI_HOME>\oracledi\agent\drivers+ and Users\<name>\Application Data\odi\oracledi
Restart the ODI and start the localagent.
created an MySQL server and a physical schema in odi.
the connection test to the server --> successful
i create a new model and start the reverse engineein --> error

oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.mysql.jdbc.Driver]
at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:107)
at oracle.odi.core.DataSourceManager$LoginTimeoutDataSourceProviderProxy.configure(DataSourceManager.java:303)
at oracle.odi.core.DataSourceManager.createAndConfigureDataSourceProvider(DataSourceManager.java:226)
at oracle.odi.core.DataSourceManager.access$0(DataSourceManager.java:206)
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:1975)
at oracle.odi.core.DataSourceManager.getDataSource(DataSourceManager.java:155)
at oracle.odi.core.OdiInstance.lookupDataSource(OdiInstance.java:788)
at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:50)
at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:944)
at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:994)
at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:959)
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1015)
at oracle.odi.ui.action.SnpsPopupActionReverseHandler$1.doInBackground(SnpsPopupActionReverseHandler.java:115)
at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:139)
at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker.run(SwingWorker.java:279)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:656)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.mysql.jdbc.Driver]
at oracle.odi.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:175)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.<init>(DriverManagerDataSource.java:107)
at oracle.odi.core.datasource.provider.DriverManagerDataSourceProvider.doCreateDataSource(DriverManagerDataSourceProvider.java:35)
at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:98)
... 20 more

solution approaches:
user and password --> correct
reverse engineering with MySQL workbench --> successfull
use the last mysql connector-java version --> yes 5.1.18
wirte the schema and workschema uppercae --> yes
user privilege --> create, drop, insert, select ... all privilege

who can give me advice or help ??


thank you!!

Edited by: 913099 on 15.02.2012 04:24