Testing ODI Connectivity to Salesforce Errors "Driver class [weblogic.jdbc.sforce.SForceDriver] does not accept URL"
(Doc ID 2563150.1)
Last updated on JANUARY 11, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to test an Oracle Data Integrator (ODI) data server connection created for a Salesforce technology, the following error occurs:
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: Driver class [weblogic.jdbc.sforce.SForceDriver] does not accept URL [jdbc.weblogic:sforce//https://<SALESFORCE_HOSTNAME>;<JDBC_PARAMETERS>]
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:472)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1152)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:909)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$11.doInBackground(SnpsDialogTestConnet.java:867)
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:748)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |