Forum Discussion

easyfish's avatar
easyfish
Contributor
9 years ago

How retrieve data source automatically once soapui starts up

Hi,   Now  I  have oracle jdbc as my data source. Once I quite soapui and rerun soapui, all the values in data source are lost. I have to click the green triangle icon and retrieve value from datab...
  • NataliaB's avatar
    NataliaB
    9 years ago

    If you have your connection established, you should be able to run the whole project, test suite or test case and this should execute all test steps including retrieving data from the db.

     

    Can you please give an example of a structure for you tests? Becides I use db as a data source as well and I don't need to run it separatly for each step.

easyfish's avatar
easyfish
Contributor

1. I have to quite SoapUI often each day, ten of times. because of the test step can not be opened, or test step does not run properly, efter quit and start soapui again, all work well.  

 

2. I have one different data source for each test step, sorry, only few test steps can share the same data source. 

 

I can put all the data sources and test steps under one test case. It does't help.  I have refresh each test source.  I have to press the button as manytimes as the number of my data source. 

 

Could you please help me to find a solution?

 

 

 

 

 

 

NataliaB's avatar
NataliaB
Occasional Contributor
9 years ago

do you use DataBases tab on top right menu (under start, project, soapui ng...)?

you can add as many connections as you need here, and establish a connection using them instead of going to a specific test.  

  • easyfish's avatar
    easyfish
    Contributor
    9 years ago

    Sorry, I need to explain a bit more.   It might confuse you before. 

    I connect to one data source with jdbc oracle.

    The data source in the above messages means test suite - test case - test step - data source, 

    The data source is the test step that I inserted for soap request.   

    I need to refresh each data source for the related soap quest test step  each time efter I start up soapui, so I would like to retrieve data source automatically - it means to get values for all the properties in data source. 

     

    • NataliaB's avatar
      NataliaB
      Occasional Contributor
      9 years ago

      If you have your connection established, you should be able to run the whole project, test suite or test case and this should execute all test steps including retrieving data from the db.

       

      Can you please give an example of a structure for you tests? Becides I use db as a data source as well and I don't need to run it separatly for each step.

      • easyfish's avatar
        easyfish
        Contributor
        9 years ago

        Thanks for your kind reply. Now I have several data sources and several related soap request under one test case, therefore I need to retrieve each data source under the test case. Yes, I can run the project, the test suite and test case without retrieving data. I need to reorginize the test steps.