bojasna
Occasional Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
JDBC Request errors when semicolon is included in SQL
When you end your sql statement with a semicolon in JDBC Requests, soapUI fails to run the request and reports the following error: "Error getting response; java.sql.SQLSyntaxErrorException: ORA-00911: invalid character" I'd like to run several sql statements in one jdb step and this is making me create a lot of jdbc steps. I see it has already been reported but archived: https://community.smartbear.com/t5/API-Functional-Security-Testing/JDBC-Request-errors-when-semicolon-is-included-in-SQL/td-p/14870 Do you know of a workaround? Strangely enough I found that I get the error if I send a call like this: GRANT SELECT ON TABLENAME TO USER; But it works with the following statement: CREATE OR REPLACE FUNCTION USER.NUMBER ( input VARCHAR2 ) RETURN VARCHAR2 IS begin if input is null then return null;Solved3KViews0likes8CommentsRe: Running a test step in another project from a mockservice
Hi richie Thanks a lot for the tip since I read something under number 4 on the link you pasted that might help me with what I want to achieve. Do you have suggestions for the title since I honestly don't know how to make it 'more searchable'. Cheers, Bojana1.9KViews0likes0CommentsRunning a test step in another project from a mockservice
Hi, I have two projects, one is a mockservice where I extract a value from the request, save it as a global property and then I use it in another project which is a regular one where I have a test suite with one one step. However, I need to execute this step manually since I see that in the scripts part in the mockservice the TestRunner property is not available( I read that this one is used for running test cases from other projects but works only from a groovy script). Is there a way that I can execute this step in the other project automatically after receiving the request in the mockservice? Thanks, Bojana Thanks, BojanaSolved2KViews0likes4CommentsBody request parameters not being created after Swagger definition import
Hi, I'm trying to import a Swagger 2.0 definition to SoapUI, but after doing so the request parameters aren't automatically generating, defeating the purpose of the import. I've also tried to import the example petstore swagger file and even there the body in the post calls is empty even though I can see that there is content when I check the swagger file in the swagger editor. Am I missing something? I have installed the plugins (I believe the latest ones) and I believe the version of the swagger file is correct since it doesn't allow me to import the 3.0. Also I tried importing collections from Postman and in case I have an attribute defined like this: "Expected_Product_Duration": "<hh:mm:ss>" It doesn't import the body request parameters unless we delete the <>. This is not that such of an issue I just thought it would be nice to mention it in case other people encounter the same. Thanks, Bojana PS I found this topic but I don't see how it was resolved, if it was resolved at all: https://community.smartbear.com/t5/SoapUI-Pro/Body-request-parameters-not-being-created-after-Swagger/td-p/152271Solved