I tried to configure Oracle ODI 12c with salesforce driver and get error:
java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]General error: java.lang.ClassCastException: com.sun.proxy.$Proxy73 cannot be cast to com.ddtek.sforce.externals.javax.xml.ws.BindingProvider at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1258) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:204) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$500(SnpsDialogTestConnet.java:62) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:402) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:398) 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.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]General error: java.lang.ClassCastException: com.sun.proxy.$Proxy73 cannot be cast to com.ddtek.sforce.externals.javax.xml.ws.BindingProvider at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 moreCaused by: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]General error: java.lang.ClassCastException: com.sun.proxy.$Proxy73 cannot be cast to com.ddtek.sforce.externals.javax.xml.ws.BindingProvider at com.ddtek.jdbc.sforcebase.ddcn.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcn.a(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforce.SForceImplConnection.c(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.b(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.m(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.e(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.a(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseDriver.connect(Unknown Source) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331) ... 6 more
Anyone has same issue? How can I resolve this issue.
Is this a trial version of the SFDC driver? What is the OS the driver is installed on? Please provide the steps to reproduce the error.
we are facing the same problem, thats why I answer to cour question.
We downloaded the trial version of the SFDC Driver (we tried both versions). We installed them and added the sforce.jar to the Classpath. Then we followed the steps mentioned here: www.ateam-oracle.com/.../. When we were trying to test the connection we became the Error mentioned above.
What we've found out is, that with the ODI 184.108.40.206.0 it seems to work, but when we are using the ODI 220.127.116.11.0 (same JDK (i.e. 1.8.0 U 111), same Enviroment) we are getting this error. Also with the Version 18.104.22.168.6.
Maybe it is an issue with some new classes of the new Version of ODI?
Do you see any chance that this will be fixed?
Thanks for providing this additional information related to this working in a previous version of Oracle ODI. Since this works with ODI 22.214.171.124.0, have you had a chance to reach out to Oracle support for information on what might have changed in more recent versions of ODI?
Since the driver redistributes some classes from the javax.xml.ws package, could this issue be related to your CLASSPATH? where is the sforce.jar in the CLASSPATH used by ODI? If you move the sforce.jar to the end of the CLASSPATH does the behavior change?
If this is determined to be an issue with the driver, the we would like to get this issue resolved. Could you please send an email or call to open a support case so that we can troubleshoot further? Once the case is opened, the support rep may be able to leverage our relationship with Oracle to contact someone there for additional assistance.
normaly the jar file has to be added in a seperate folder, which enhances the classpath. I couldn't exactly determine how the classpath is set when executing the application, but there are several conf-files, which are adding additional jars to the application, when it get started.
So I added the sforce.jar on the very first place of the first included conf-file and this seems to work. So I assume, by adding it the "right" way, the application launcher will add the jar file at the end of the classpath and then there is a class error because of another lib file which have the same class, but another version.
Now the question is which lib is provoking this issue and will the ODI run normal, by adding the lib in this way. Maybe Orcale uses now a newer version of a lib?
I have no chance to get an oracle rep to examine this, and I think the oracle support will not help, because this external jdbc driver isn't officaly supported.
Yes, we are trying with trial version of SFDC driver on Windows 2008 Server. Oracle ODI Standalone version 12.
Steps to reproduce follow this link:
Issue when testing connection at step: Create Salesforce Data Server: