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
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 info: media.datadirect.com/.../help.html