Forum Discussion

kadir's avatar
kadir
Occasional Contributor
11 months ago

readyapi Database connection

in our project, when I add a datasource step and try to add, and choose JDBC as Data Source, and try to add connection I get a pop that says "Connection properties have changed. Do you want to build ...
Data-Driven Testing
El-Jodi's avatar
El-Jodi
Occasional Contributor
11 months ago

Hi kadir

this is not an unusual behaviour, unfortunately. Probably has to do something with retrieving all the table information. I use the workarround of creating my DB query in a dedictaed DB tool (eg. DB visualizer or Squirrel or even an editor).

When readyapi asks me if I want to build a query I press no and paste the query directly into the query window. 

Saves me a lot of time.

Regards

Holger

  • ChrisAdams's avatar
    ChrisAdams
    Champion Level 3
    11 months ago

    I do exactly the same thing for this reason.  Not ideal and maybe SmartBear should improve it, but El-Jodi 's suggestion is a very good workaround

  • richie's avatar
    richie
    Community Hero
    11 months ago

    Hey kadir 

    ChrisAdams  & El-Jodi are spot on - people were posting about how slow and problematic the query builder function is over 3 years ago.  Looks like SmartBear never got around to fixing the issue

    ta

    rich