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 becon.executeUpdate("UPDATE DDT SET I_COMMODITY_CODE='99999' where TEST_STEP_ID='3.3.3'")? And I belive you need import of goovy.sql.*9 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.1KViews0likes1CommentRe: 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.9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.8KViews0likes1CommentRe: 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.9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.9KViews0likes1CommentRe: How retrieve data source automatically once soapui starts up
do youuse 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.9 years agoPlace ReadyAPI QuestionsReadyAPI Questions2KViews0likes3CommentsRe: Data not transfered
you might neeed to use a property transfer step (from testStep A to testStep B)9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.4KViews0likes1CommentRe: 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=true9 years agoPlace ReadyAPI QuestionsReadyAPI Questions713Views0likes0CommentsRe: 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,ROWNUMBER, YOUR TEXT)) //close the file copy.write(); copy.close(); workbook.close();9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.8KViews0likes0Comments