ContributionsMost RecentMost LikesSolutionsHello.. Need Urgent help..Unable to open my project in the SoapUI Workspace I worked on my SoapUI Project the whole day and I am unable to open my project in SOAPUI Workspace , My tests do not show up. Pls help as I am worried my tests are all gone.. Re: Hello.. Need Urgent help..Unable to open my project in the SoapUI Workspace Thank you for your reply. I was able to get around it somehow. Seems like soapui creates a "temp" xml file when it gets crashed or closed. I had so my of these in my folder . i went through every temp file and finally could find a file right before my project got corrupted. thank god.. next time I guess I should have multiple back ups of my file Re: Hello.. Need Urgent help..Unable to open my project in the SoapUI Workspace Hello, Yes I constantly save my project. When I edit the xml file , i do see the contents in there I did get an outofmemory exception when I tried to save one time. it complained about insufficient heap space So I could not save some tests butI would expect the rest of my tests to be available atleast Re: Hello , I recently upgraded to soap15.3 version and some of my JDBC test cases are failing I managed to find an older version (15.2.1) and installed in my Virtual machine and I can confirm that it worked in there. Re: Hello , I recently upgraded to soap15.3 version and some of my JDBC test cases are failing Thanks for your reply! I do not have an older version of soapui. I could not find it in the website too. I cant think of any environmental change . Any idea what I should be looking for? Hello , I recently upgraded to soap15.3 version and some of my JDBC test cases are failing I have some test cases with JDBC test steps. Some of the JDBC tests are suddenly failing select * from tblAssignedExternalAccounts where FKAccountNumber=17 select * from tblExternalProducts where ExternalProductsKeyId=15 If I remove the second line it returns the response fine, but with this, I keep getting java.sql.SQLException: ResultSet is closed. I have lot of tests with this type of queries . Please suggest!. I am using ODBC driver for connections Driver: sun.jdbc.odbc.JdbcOdbcDriver Connection string: jdbc:odbc:{Driver name configured} I use SqlServer database Re: Validating a DateTime from a JSON response to Today's date Thanks it worked! Re: Validating a SOAP response XML against a JDBC response XML Thanks for your reply! As you mentioned, I have soap request and jdbcc step and I have assertions added to both. I am quite new to groovy, so I am not familiar to calling test steps within the script and do a compare. Here is a sample script I tried to obtain my node values from soap request . The X path mentioned in the GetNodeValues works only when I give the path upto the node . This does not work for me since the response is pretty huge and i can validate every single node separately def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context) def holder= groovyUtils.getXmlHolder("Max -UpdateAccountShipTo#Response") holder.namespaces["ns1"]="http://tigerpaw.com/service/" holder.namespaces["a"]="http://tigerpaw.com/contract/" for (item in holder.getNodeValues("//ns1:UpdateAccountShipToResponse/ns1:UpdateAccountShipToResult/a:ShipTo")) log.info "item/:[$item]" This outputs item:[] Howvere if I i modify getNodeValues ("//ns1:UpdateAccountShipToResponse/ns1:UpdateAccountShipToResult/a:ShipTo/a:Name" outputs item [Name] Validating a SOAP response XML against a JDBC response XML I am using SoapUi 5.2 and I am trying to validate a SOAP response XML against a JDBC test response Both belon to same test case. Both of these have the same content and but the nodes are named differently. I need to assrt it as PASS if the corresponding node values are same For eg: In JDBC Results> <ResultSet fetchSize="0"> <Row rowNumber="1"> <ALTSHIPTOKEYID>27</ALTSHIPTOKEYID> <ACCOUNTNUMBER>10022</ACCOUNTNUMBER> </Row> </resultSet> </results> SOAP: <UpdateAccountShipToResult > <a:ShipTo> <a:ShipToID>27</a:ShipToID> <a:AccountNumber>10022</a:AccountNumber> </a:ShipTo> Is there a way to validate both these XML using groovy? Validating a DateTime from a JSON response to Today's date I have a testcase using a REST-JSON request. When ever I do a POST , it returns the dateCreated . Since this changes everytime I do a POST ,how do I validate this? Also the response is in JSOn format. The response is "DateCreated":"2015-07-20T09:56:35.263" Any help would be appreciated! Solved