ricardo_mouraOccasional ContributorJoined 8 years ago13 Posts1 LikeLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsRe: execute oracle script from JDBC teststep l solve adding "COMMIT;" between end loop; and END; execute oracle script from JDBC teststep hello, i have below script to execute on oracle database: DECLARE v_sender NUMBER (20,0):= 10000000000001; BEGIN DELETE FROM table_A where key_field between 10000000000001 and 10000000000050; FOR x IN 1..50 LOOP insert into table_A (key_field, field1, field2) VALUES (v_sender, 1234, 1234); v_sender := v_sender + 1; END LOOP; END; if i execute on sql developer client, works fine, but via JDBC teststep on soapUI, does not work, soapui just stay executing, executing and executing for ever my conection with DB its OK, i can execute simple selects, updates and deletes without any problems thanks in advance SolvedRe: Does Soap ui supports swagger 3.0 or open api 3.0 importing api spec (json) file when i use "import swagger" function, the soapui shows me follow message: "groovy.json.JsonException: Unable to determine the current character, it is not a string, number, array, or object The current character read is 'o' with an int value of 111 Unable to determine the current character, it is not a string, number, array, or object line number 1 index number 0 openapi: 3.0.0 ^" i was able to import after edit yaml/json spec: change (openapi: 3.0.0) to (swagger: "2.0") on first line of archive Re: REST Method parameter styles - TEMPALTE nmrao, i just checked my OS soapUI, and "TEMPLATE" option is still available, strange, try re-install yout aplication. i'm using SoapUI 5.4.0 regards, Re: JSON view started showing as a single line of text that happens because your request level "Pretty print" property probably is "False", change it to "true" and send request again: Re: how to transfer result of groovy script you can use following lines in your groovy script step: def profiel = UUID.randomUUID() testRunner.testCase.setPropertyValue("TestCasePropertyName", profiel.toString()) and on next request step, put "${#TestCase#TestCasePropertyName}" where you want the UUID value. regards Re: Is it possible to pass a property as access token in SOAP UI? thank you so much works fine for me how to include response fields in contract coverage test? hello my friends i received a .json swagger definition of resources and fields of each one like below: "FieldA": { "type": "object", "description": "is required", "properties": { "fieldA1": { "type": "string" }, "fieldA2": { "type": "string" }, "fieldA3": { "type": "string" }, "fieldA4": { "type": "string" }, "fieldA5": { "type": "string" } } } and i need to do contract coverage test, but when i run it, i get only status of messages coverage results, i can include all fields of my .json definition on coverage test? i want show for team how much of definitions my tests cover thanks for all Re: how to get MockResponse "Name" property value? i able, but not is the best way, with this method i set/get custom property from MockService, not from MockResponse i have a lot of MockResponses, do that to everyone costs a lot of time Re: how to get MockResponse "Name" property value? thanks for fast reply Anastasia in both scripts, the aplication only can get MockService properties value, i need obtain mockResponse's name, 2 levels below on the project tree: I created in the MockService a custom property called "resultName" for the following script, insert an "hard coded" value and, with your second script, to get the property value and log it. def resultName = context.mockService.setPropertyValue("resultName","Response1") It works fine, but I have many mock responses and does this for each is unviable. thanks again