Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can ODI 11.1.1.7.0 connect to Mysql Database with a standalone agent or does it have to be a Weblog

Revanth TambisettyOct 29 2013 — edited Nov 12 2013

Im trying to connect to connect to MySQL Database 5.x with ODI 11.1.1.7.0 with a standalone agent. it connects successfully with a local agent but fails with a Standalone Agent with an error message

oracle.odi.runtime.agent.invocation.InvocationException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:780)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:584)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$10(SnpsDialogTestConnet.java:581)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:558)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:1)

at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

at java.lang.Thread.run(Thread.java:662)

Please note The ODI server does not have weblogic.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2013

Added on Oct 29 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

1,238 views