Contributions
Ready APi Not able to run procedure with clob output type parameter in it
Hi, I am able to connect to db using groovy but when i am trying to run procedure using groovy then its coming in the catch block. It has 2 input and 3(1 as CLOB type, 1 as Integer, 1 as Varchar) out parameters And If i use getMessage method in the catch method then its giving me the xml which i am supposed to get but.with the below error message. ERROR: Execption occuredNo signature of method: Script87$_run_closure1.doCall() is applicable for argument types: (java.lang.String, java.lang.String, java.lang.String) values: Can anyone please let me know how can i handle CLOB output type here as i think i am getting above error message because i am passing SQL.VARCHAR in the below highlighted instead of some way to identify CLOB output parameter. I tried SQL.CLOB but its not a valid column type Syntax to run the proc which return code as 1 and dnt go in to catch block: try{ sql.call ('{call GET_OPEN_ORDER(?, ?, ?,?,?)}', ['80469098637', 'CALL_CENTER', Sql.VARCHAR, Sql.INTEGER, Sql.VARCHAR]) } catch (e){ log.error "Execption occured"+e.getMessage() } Syntax to run the proc which goes in to catch block: try{ sql.call ('{call GET_OPEN_ORDER(?, ?, ?,?,?)}', ['80469098630', 'CALL_CENTER', Sql.VARCHAR, Sql.INTEGER, Sql.VARCHAR]) { results ->log.info results } } catch (e){ log.error "Execption occured"+e.getMessage() } Kindly let me know how can i handle CLOB output paramete using groovy so that i dont get exception message as mentioned above. Thanks, HimanshuSolved2KViews0likes5CommentsRe: Ready APi Not able to run procedure with clob output type parameter in it
Thanks for your reply. The database I am using is oracle and the way you mentioned is not working for me because my db is not sql I guess that's the reason4 years agoPlace ReadyAPI QuestionsReadyAPI Questions2KViews0likes2CommentsRe: Soapui Maven -Exception in request: javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated
Thanks for the reply.. ..i still have a doubt here i am running my soapui project from maven so how would changing the bat file will suffice the purpose. Dont we need to add some plugin/dependency in pom.xml for this or may be something we need to pass in maven goal. Kindly confirm and correct my understanding.2.5KViews0likes6CommentsSoapui Maven -Exception in request: javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated
Hi, I am getting below error in soap ui 5.4 version when running my project through maven. Although in soap ui its working fine after adding ssl settings. SoapUIMultiThreadedHttpConnectionManager$SoapUIDefaultClientConnection] Connection shut down 19:26:28,791 Error [WsdlSubmit] Exception in request: javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated 19:26:28,791 ERROR [SoapUI] An error occurred [peer not authenticated], see error log for details javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated at sun.security.ssl.SSLSessionImpl.getPeerCertificates(SSLSessionImpl.java:431) at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:128) Java version is 1.8. Anonymous can you please let me know the fix for this. Thanks, Himanshu2.6KViews0likes8CommentsMongo Db query not working in JDBC TestSTep of Ready API
Hi, I am able to connect to mongo db after placing the mongodb_unityjdbc_full driver in ext folder. But i am not sure how i can run query from jdbc test step. I tried following the mongo db syntax but its throwing below errror message: 2018-12-26 07:25:54.543 - Error getting response; java.sql.SQLException: Parse Exception: unity.parser.ParseException: Encountered " "(" "( "" at line 1, column 17. Was expecting: ";" ... Input query: db.customer.find({leadId:"83863270"}, {accountState:1,leadId:1,_id:0}); Can someone please help me how i can place query under sql query section of jdbc test step for mongo db ?. Please see the image for your reference6 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.4KViews0likes3CommentsGetting error when running soap ui project using soapui-maven-plugin 4.6.1
Hi, I am getting below error when i am running soap ui project using soapui-maven-plugin 4.6.1. Please see below for POM and error details. My sopaui project is created in soap ui 5.1.3 version POM: <plugin> <groupId>com.smartbear.soapui</groupId> <artifactId>soapui-maven-plugin</artifactId> <version>4.6.1</version> <configuration> <projectFile>ComCastPro-soapui-project.xml</projectFile> <outputFolder>target/surefire-reports</outputFolder> <junitReport>true</junitReport> <exportwAll>true</exportwAll> <printReport>true</printReport> <testFailIgnore>false</testFailIgnore> </configuration> </plugin> Error: 13:27:47,440 ERROR [WsdlSubmit] Exception in request: org.apache.xmlbeans.impl.values.XmlValueOutOfRangeException: string value 'No Authorization' is not a valid enumeration value for type of authType element in Credentials in namespace http://eviware.com/soapui/config 13:27:47,440 ERROR [SoapUI] An error occurred [string value 'No Authorization' is not a valid enumeration value for type of authType element in Credentials in namespace http://eviware.com/soapui/config], see error log for details org.apache.xmlbeans.impl.values.XmlValueOutOfRangeException: string value 'No Authorization' is not a valid enumeration value for type of authType element in Credentials in namespace http://eviware.com/soapui/config at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.set_text(JavaStringEnumerationHolderEx.java:39) at org.apache.xmlbeans.impl.values.XmlObjectBase.update_from_wscanon_text(XmlObjectBase.java:1166) at org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated(XmlObjectBase.java:1305) at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.getEnumValue(JavaStringEnumerationHolderEx.java:60)948Views0likes0CommentsSoaui Maven plugin 5.0.0/5.1.3/5.1.0 not working properly
Hi, I am getting below error while downloading soap ui maven plugin. I created my soap ui project in 5.1.3 and when running the same from maven project then its throwing below error. I tried with 3 versions of soap ui maven plugin 5.0.0, 5.1.3 and 5.1.0 for all its throwing me below error. Can any one please help me here? Failed to execute goal com.smartbear.soapui:soapui-maven-plugin:5.1.0:test (default-cli) on project ComCastPro: Execution default-cli of goal com.smartbear.soapui:soapui-maven-plugin:5.1.0:test failed: Plugin com.smartbear.soapui:soapui-maven-plugin:5.1.0 or one of its dependencies could not be resolved: Could not transfer artifact com.btr:proxy-vole:jar:20131209 from/to smartbear-sweden-plugin-repository (http://www.soapui.org/repository/maven2/): Access denied to http://www.soapui.org/repository/maven2/com/btr/proxy-vole/20131209/proxy-vole-20131209.jar. Error code 403, Forbidden -> [Help 1] Copying POM details also: <plugin> <groupId>com.smartbear.soapui</groupId> <artifactId>soapui-maven-plugin</artifactId> <version>5.1.0</version> <configuration> <projectFile>ComCastPro-soapui-project.xml</projectFile> <outputFolder>target/surefire-reports</outputFolder> <junitReport>true</junitReport> <exportwAll>true</exportwAll> <printReport>true</printReport> <testFailIgnore>false</testFailIgnore> </configuration> </plugin>839Views0likes0Comments