Dymitr
New Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Data Source Properties doesn't populate with information from SQL query
Hi, I am currently using Ready API 3.10.1. I want to retrieve information from Oracle DB with "Data Source" test step and pass value to the property. I did next steps: 1."ojdbc8.jar" file was added to <installationFolder>\bin\ext. 2.JDBC configuration window - I chose "OracleThin/oracle.jdbc.driver.OracleDriver" and filled out all necessary fields. 3. I have checked connection with button "Test the current connection" and got result "The connection has been tested successfully". 4. "Build a query" - I wrote a select to view and executed with max rows = 1 Second tab with result. This means, that the information from the Oracle DB was received and ReadyApi should have been passed this value to the property. But when I execute my "Data Source" step, I get fields with empty result Accordingly, my property gets the value "empty" and it's useless in the following steps. My question is: How I can configure the ReadyApi to populate "Data Source" property with information from Oracle DB? P.S. I used the following tutorial: https://www.youtube.com/watch?v=8yTJYg8DxO8&ab_channel=SmartBear
