Initial Test Connection works fine using oracle thin driver - however when I try to build a query... it just gets stuck and eventually ReadyAPI freezes and I have to end it from task manager.
Any suggestion on how I can build a query from oracle database?
Solved! Go to Solution.
trying to just pull one record..
here is my sql statement below ... just simple query to get 1 active account_number but it just freezes up.
SELECT DISTINCT c.account_number
FROM hz_cust_accounts c , ra_customer_trx_all t
AND t.bill_to_customer_id = c.cust_account_id
and t.creation_date > sysdate - 30
AND c.status = 'A'
order by dbms_random.value() FETCH FIRST 1 ROW ONLY
So I tried putting the sql directly into the editable part.... but "run" button is grayed out 😭 and of course if I click on "Build Query" it locks up
Meanwhile - i created a groovy script to connect to the database to do the querying... did not want to do that route .. as I wanted to make it user friendly for folks that are new to ReadyAPI (like myself)
wow.. i am going to cry.. this worked perfectly. Thank you so much!! We are grilling right now, I wish I can fix you a plate!
What is this "Build Query" button there for? Whenever I click that this stupid thing locks up and I have to kill it via Task Manager. 😞
I added a Step "JDBC Request" to my TestCase (there is no "JDBC Step" as you write, so I guess that's what you meant).
When I select that and configure the connection and click "Test Connection" I get "Connection tested successfully".
I also can enter some SQL statement and hit the green triangle and the query is executed.
But when I hit "build query" the whole thing locks up and I have to kill it. So what's the point or intended functionality of this "build query" button? I found no explanation or description of it.