NaveenKumar11
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: how to execute/call stored procedure from soap ui open source tool
Thanks for your response. Based on the link you shared i have tried below, execute SID_SRCH.CUSTOMER_TEXT_SEARCH('23902072','1234','john','pistorio','1952-07-15','Vincenne','Indiana','47591','45454','4561237892',SYS_REFCURSOR) error message INFO:Error getting response for [Copy of JDBC Request]; java.sql.SQLException: ORA-06550: line 1, column 15: PLS-00103: Encountered the symbol "SID_SRCH" when expecting one of the following: := . ( @ % ; immediate The symbol ":=" was substituted for "SID_SRCH" to continue.3KViews0likes0Commentshow to execute/call stored procedure from soap ui open source tool
Hi All, Please help me to execute/call stored procedure from soap ui open source tool. I am looking for syntax or sample code to proceed further. schema name: SID_SRCH stored proc name: CUSTOMER_TEXT_SEARCH This stored proc contains 9 input parameters and 1 output parameters polnumber - varchar2 (200) ssn - varchar2 (200) firstname - varchar2 (200) lastname - varchar2 (200) dob - varchar2 (200) city- varchar2 (200) state- varchar2 (200) zip- varchar2 (200) productline - varchar2 (200) phonenumber- varchar2 (200) user_cur - SYS_REFCURSOR Please help me to frame query to enter under "SQL Query" under "JDBC Request"3.1KViews0likes2CommentsRe: Groovy script to compare two text files
Thanks for your response. Actually there will be some upgrade in the server. Before upgrade, i need to run my request against the server and i ll capture response and store in my drive. After upgrade i need to hit the same server with the same request. At that time i need to compare the current response with the already stored response dynamically using groovy. test data is normal xml response. <?xml version="1.0" ?> <Process> <Execution> <Execution_Date>2015/11/16 15:58:05</Execution_Date> <Process_File>Sample_2015-11-16_153023.xml</Process_File> <Client>IBLLC</Client> <Client_Master_Acct>FXXXXXXX</Client_Master_Acct> </Execution> <Applications> <Application External_ID="ABCD1002" Status="Success"> <Customer>Joseph Clientman</Customer> <Users> <User external_id="ABCD1002USR" password="xxxxxxxx">jocmn841</User> </Users> <Accounts> <Account external_id="ABCD1002AC">UXXXXXXX</Account> </Accounts> <Entities> <Entity external_id="ABCD1002AH">20951330</Entity> </Entities> <Pending_Tasks> <Task Task_Number="87745956" Form_Number="1005" Form_Name="Margin Agreement" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745947" Form_Number="2192" Form_Name="Privacy Statement" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745948" Form_Number="3007" Form_Name="Customer Agreement (v2)" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745949" Form_Number="3024" Form_Name="Forex and Multi-Currency Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745955" Form_Number="3044" Form_Name="US Bond Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745950" Form_Number="3070" Form_Name="Business Continuity Plan Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745951" Form_Number="3071" Form_Name="Day Trading Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745952" Form_Number="3074" Form_Name="Order Routing and Payment for Order Flow Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745963" Form_Number="3076" Form_Name="ISE Disclosure for Option Orders Over 500 Contracts" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745964" Form_Number="3077" Form_Name="Municipal Bond Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745968" Form_Number="4003" Form_Name="OCC Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745953" Form_Number="4016" Form_Name="After-hours Trading Risk Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745941" Form_Number="4035" Form_Name="Mutual Fund Agreement" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745973" Form_Number="4036" Form_Name="Mutual Fund Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745936" Form_Number="6105" Form_Name="Client FA Agreement" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745937" Form_Number="6108" Form_Name="Agreement Limiting Interactive Brokers Liability" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> <Task Task_Number="87745981" Form_Number="9130" Form_Name="US Stock Stop Order Disclosure" Action="to sign" Is_Required_For_Approval="true" Is_Required_For_Trading="false" Is_Online_Task="true"></Task> </Pending_Tasks> </Application> </Applications> </Process>11KViews0likes12CommentsSSL Handshake exception occurred while testing REST API service
Error message in the log: Thu Dec 22 14:10:55 IST 2016:DEBUG:Sending request: CONNECT uat-agentservices.washingtonnational.com:443 HTTP/1.1 Thu Dec 22 14:10:55 IST 2016:DEBUG:Receiving response: HTTP/1.1 200 Connection established Thu Dec 22 14:10:55 IST 2016:DEBUG:Tunnel to target created. Thu Dec 22 14:10:55 IST 2016:DEBUG:Attempt 1 to execute request Thu Dec 22 14:10:55 IST 2016:DEBUG:Sending request: POST /Mobility/pmamobile/userLogin/login HTTP/1.1 Thu Dec 22 14:10:56 IST 2016:DEBUG:I/O error closing connection javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure at sun.security.ssl.SSLSocketImpl.checkEOF(Unknown Source) at sun.security.ssl.SSLSocketImpl.checkWrite(Unknown Source) at sun.security.ssl.AppOutputStream.write(Unknown Source) at org.apache.http.impl.io.AbstractSessionOutputBuffer.flushBuffer(AbstractSessionOutputBuffer.java:131) at org.apache.http.impl.io.AbstractSessionOutputBuffer.flush(AbstractSessionOutputBuffer.java:138) at org.apache.http.impl.conn.LoggingSessionOutputBuffer.flush(LoggingSessionOutputBuffer.java:95) at org.apache.http.impl.AbstractHttpClientConnection.doFlush(AbstractHttpClientConnection.java:270) at org.apache.http.impl.SocketHttpClientConnection.close(SocketHttpClientConnection.java:245) at org.apache.http.impl.conn.DefaultClientConnection.close(DefaultClientConnection.java:164) at org.apache.http.impl.conn.AbstractPooledConnAdapter.close(AbstractPooledConnAdapter.java:152) at org.apache.http.protocol.HttpRequestExecutor.closeConnection(HttpRequestExecutor.java:142) at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:129) at org.apache.http.impl.client.DefaultRequestDirector.tryExecute(DefaultRequestDirector.java:633) at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:454) at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820) at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754) at com.eviware.soapui.impl.wsdl.support.http.HttpClientSupport$Helper.execute(HttpClientSupport.java:233) at com.eviware.soapui.impl.wsdl.support.http.HttpClientSupport.execute(HttpClientSupport.java:323) at com.eviware.soapui.impl.wsdl.submit.transports.http.HttpClientRequestTransport.submitRequest(HttpClientRequestTransport.java:297) at com.eviware.soapui.impl.wsdl.submit.transports.http.HttpClientRequestTransport.sendRequest(HttpClientRequestTransport.java:227) at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:119) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure at sun.security.ssl.Alerts.getSSLException(Unknown Source) at sun.security.ssl.Alerts.getSSLException(Unknown Source) at sun.security.ssl.SSLSocketImpl.recvAlert(Unknown Source) at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source) at sun.security.ssl.SSLSocketImpl.writeRecord(Unknown Source) at sun.security.ssl.AppOutputStream.write(Unknown Source) at org.apache.http.impl.io.AbstractSessionOutputBuffer.flushBuffer(AbstractSessionOutputBuffer.java:131) at org.apache.http.impl.io.AbstractSessionOutputBuffer.flush(AbstractSessionOutputBuffer.java:138) at org.apache.http.impl.conn.LoggingSessionOutputBuffer.flush(LoggingSessionOutputBuffer.java:95) at org.apache.http.impl.io.ContentLengthOutputStream.flush(ContentLengthOutputStream.java:102) at org.apache.http.entity.ByteArrayEntity.writeTo(ByteArrayEntity.java:69) at org.apache.http.entity.HttpEntityWrapper.writeTo(HttpEntityWrapper.java:96) at org.apache.http.impl.client.EntityEnclosingRequestWrapper$EntityWrapper.writeTo(EntityEnclosingRequestWrapper.java:108) at org.apache.http.impl.entity.EntitySerializer.serialize(EntitySerializer.java:120) at org.apache.http.impl.AbstractHttpClientConnection.sendRequestEntity(AbstractHttpClientConnection.java:263) at org.apache.http.impl.conn.AbstractClientConnAdapter.sendRequestEntity(AbstractClientConnAdapter.java:227) at org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecutor.java:255) at com.eviware.soapui.impl.wsdl.support.http.HttpClientSupport$SoapUIHttpRequestExecutor.doSendRequest(HttpClientSupport.java:119) at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:123) ... 14 more Thu Dec 22 14:10:56 IST 2016:DEBUG:Closing the connection. Thu Dec 22 14:10:56 IST 2016:DEBUG:Connection closed Thu Dec 22 14:10:56 IST 2016:DEBUG:Connection shut down Thu Dec 22 14:10:56 IST 2016:ERROR:Exception in request: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure Thu Dec 22 14:10:56 IST 2016:ERROR:An error occurred [Received fatal alert: handshake_failure], see error log for details Thu Dec 22 14:10:56 IST 2016:INFO:Error getting response for [https://uat-agentservices.washingtonnational.com.Login:Request 1]; javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure For the above i have already appended the below code in the soap ui. vmoptions file -Dsoapui.https.protocols=TLSv1.2,SSLv3 But still i am getting the error message. please help me to resolve this exception. Am i need to update anything in the soapui.bat file?1.7KViews0likes0Comments