cancel
Showing results for 
Search instead for 
Did you mean: 

How retrieve data source automatically once soapui starts up

SOLVED
Contributor

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 database for each data source. 

I am wondering how I can retrive data value  automatically from database once soapui is started.  Now the issue is very critical for me.  

 

Thanks for your kind support in advance!

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Occasional Contributor

Re: How retrieve data source automatically once soapui starts up

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.

6 REPLIES 6
Contributor

Re: How retrieve data source automatically once soapui starts up

Ehhm, that very limited information and a strange situation. Why do you want to do this? 

 

You could put all (how much are there?) DataSources in one TestCase. Then you have to press only one button to execute all sources.

Contributor

Re: How retrieve data source automatically once soapui starts up

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?

 

 

 

 

 

 

Occasional Contributor

Re: How retrieve data source automatically once soapui starts up

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.  

Contributor

Re: How retrieve data source automatically once soapui starts up

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. 

 

Occasional Contributor

Re: How retrieve data source automatically once soapui starts up

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.

Contributor

Re: How retrieve data source automatically once soapui starts up

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.  

New Here?
Join us and watch the welcome video:
Join the exciting event
SeptemberHubBub
Top Kudoed Authors
Join the September Hub-bub to show off, learn and win