Connecting Oracle Data Integrator (ODI 12c) using Datadirect JDBC to Salesforce - Forum - DataDirect Connect - Progress Community

Connecting Oracle Data Integrator (ODI 12c) using Datadirect JDBC to Salesforce

 Forum

Connecting Oracle Data Integrator (ODI 12c) using Datadirect JDBC to Salesforce

This question is not answered

Hi,

I downloaded Salesforce drivers for ODI and I was able to load drivers. However, I'm getting the error while testing the connection.

java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking https://test.salesforce.com/services/Soap/u/34.0: null
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:1243)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:203)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1100(SnpsDialogTestConnet.java:62)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:400)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:396)
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]java.lang.NullPointerException: NullPointerException invoking https://test.salesforce.com/services/Soap/u/34.0: null
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 more
Caused by: java.sql.SQLNonTransientConnectionException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking https://test.salesforce.com/services/Soap/u/34.0: null
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

Can you help.

Thanks,

Ganesh

All Replies
  • Hi Ganesh,

    We probably need to start with gaining some more info from you.  What version of the driver do you have?  Can you use the driver's java logging to generate logs of the problem and attach them?  I've included some links to documentation, but feel free to reach out to our support team if you haven't already.

    Thanks,

    Brody

    How can I determine what version and build of the JDBC driver I am using?

    Assuming your class path is setup correctly, you can use the following command, java <class name>. For example, to find out the version of SQL Server, type,

    "java com.ddtek.jdbc.sqlserver.SQLServerDriver"

    Java Logging infomedia.datadirect.com/.../help.html