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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.