Forum Discussion

tcarey's avatar
tcarey
Occasional Contributor
5 years ago

ReadyAPI freezes when trying to connect to oracle database

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.   An...
  • richie's avatar
    richie
    5 years ago
    Hi tcarey,

    According to the screenshot you supplied it looks like youre using a Datasource step (type JDBC). Don't.

    Use the separate 'JDBC step' instead. This will allow you to run the SQL without any problems and maintains the ease of use for non coders.

    Cheers

    Rich
tcarey's avatar
tcarey
Occasional Contributor

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)  

 

 

 

richie's avatar
richie
Community Hero
5 years ago
Hi tcarey,

According to the screenshot you supplied it looks like youre using a Datasource step (type JDBC). Don't.

Use the separate 'JDBC step' instead. This will allow you to run the SQL without any problems and maintains the ease of use for non coders.

Cheers

Rich
  • tcarey's avatar
    tcarey
    Occasional Contributor
    5 years ago

    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!

     

    Thanks again!!!!

  • mmoser18's avatar
    mmoser18
    Frequent Contributor
    5 years ago

    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.