ContributionsMost RecentMost LikesSolutionsRe: Executing stored procedure from JDBC Request Hi, Did your query resolved? I am looking answer for the same query. 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. how 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" Re: Replace complete POST Request XML Content using Groovy scrip Could you please share full script that you used for replacing complete POST Request XML using groovy. Thanks in Advance Naveen Re: 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> Groovy script to compare two text files Hi, Please share me the groovy script. to read two text files compare the above text files and print the difference Thanks Naveen SSL 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?