NataliaBOccasional ContributorJoined 9 years ago14 Posts1 LikeLikes received4 SolutionsView All Badges
ContributionsMost RecentMost LikesSolutionsRe: Old tests do not get executed after update to 1.7.0 and if I run the same raw request in a browser it returns value just fine Re: Save All Projects causes Threat Detection in TrendMicro OfficeScan Agent did you change system path to use a new version? Old tests do not get executed after update to 1.7.0 I updated version to 1.7.0 and now steps with REST request don't get executed, there is nothing in response window Re: can not update oracle table in soapui groovy In what line does this error happen? Did you test your connection string (it can be done using soapui interface)? Also this part looks confusing to me, you connection is called con not sql > sql.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'") Shouldn't it be con.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")? And I belive you need import of goovy.sql.* Re: Need function in data source to write properties to a file you can try to add a property transfer and dataSink steps. The idea is that you will transter data between you dataSource and DataSinc, and save them to a specific file. Alternatively, if you are comfortable with scripting, you can do a select from groovy (instead of using dataSource step), and save results to the file in the same script using a code example I gave you before. 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. 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. Re: Data not transfered you might neeed to use a property transfer step (from testStep A to testStep B) Re: Connecting SQL server 2014 using windows authentication 1. copy sqljdbc jar (the most recent version) to \ReadyAPI-1.6.0\bin\ext 2. copy folders xa and auth to the same place and add it to the PATH (there should be 2 folders for each, in total 4 folders to add to the path) 3. copy sqljdbc_auth.dll to \ReadyAPI-1.6.0\bin 4. restart machine Your connection string should be : jdbc:sqlserver://<SERVER_NAME>:<PORT:1433>;databaseName=<DB: DB_NAME>;integratedSecurity=true Re: Need function in data source to write properties to a file if you want to write to excel, you can try this groovy script //open your file Workbook workbook = Workbook.getWorkbook(new File("PATH TO YOUR FILE")); //set it enable to edit WritableWorkbook copy = Workbook.createWorkbook(new File("PATH TO YOUR FILE"), workbook) WritableSheet sheet = copy.getSheet("STEET NAME IN THE FILE WHERE YOU WILL WRITE") //write to a cell sheet.addCell( new Label(COLUMN NUMBER,ROW NUMBER, YOUR TEXT)) //close the file copy.write(); copy.close(); workbook.close();