shubhimu
Contributor
Joined 7 years ago
User Profile
User Widgets
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, HimanshuSolved2.1KViews0likes5CommentsRe: 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.6KViews0likes6CommentsSoapui 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 reference1.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)968Views0likes0CommentsSoaui 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>868Views0likes0Comments