"Error getting response; null" during actual JDBC request test step run with Salesforce DB
Hi,
I have successfully setup a salesforce db with ReadyApi by the following steps:
1. Add "sforce-jdbc.jar" to <installationFolder>\bin\ext
2. In Preferences>JDBC Drivers, add driver: "com.reliersoft.sforce.jdbc.Driver"
3. Value: jdbc:sforce://<link>?user=<user>&password=<password>
4. In Databases, add new connection and select the driver added in Step 1 (named it SFDB)
5. In the test case, add JDBC Request test step
6. In Configuration panel > Connection, select SFDB in the dropdown. Message pops up "Connection has changed, build Query?", select Yes.
Note: At this point, after clicking Yes, ReadyAPI pops up a message: "JdbcMetadataProvider: Failed to load metadata relations. null" then I just clicked OK
7. Build SQL Query window will open. Select any table and tick one column from the table, then click on "Test Query" button.
Result: Returns records and results from the table.
8. Click OK button.
9. Now back to JDBC Request Test Step, Test Connection -> "The Connection Successfully Tested" message pops up, click OK
10. Test the step by clicking play button "Submit request to specified database"
Expected Result: Results table from #7 will be returned
Actual Result: No data was returned. Request log message: "Error getting response; null"
Checked the logs and shows the following:
ERROR [errorlog] java.lang.NullPointerException java.lang.NullPointerException: null at com.eviware.soapui.support.xml.XmlUtils.createColumn(XmlUtils.java:1463) ~[ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.support.jdbc.JdbcUtils.parseResultSet(JdbcUtils.java:198) ~[ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.support.jdbc.JdbcUtils.createResultSetHolder(JdbcUtils.java:167) ~[ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.<init>(JdbcResponse.java:47) ~[ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:275) [ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:178) [ready-api-soapui-2.6.0.jar:2.6.0] at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:150) [ready-api-soapui-2.6.0.jar:2.6.0] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_181] at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_181] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_181] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_181] at java.lang.Thread.run(Unknown Source) [?:1.8.0_181]
Hi,
Thank you for informing us about it.
The Saleforce driver contains some issues. Nethertheless we changed the logic to avoid them. The fix is available in the ReadyAPI 2.6.0 maintenance build:
https://support.smartbear.com/downloads/readyapi/maintenance
Best regards,
Alexander Sviridov
ReadyAPI developer