NataliaB
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
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.*2.2KViews0likes1CommentRe: 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.1.9KViews0likes1CommentRe: 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.2KViews0likes1CommentRe: 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=true723Views0likes0CommentsRe: 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();1.9KViews0likes0Comments