Contributions
Re: Apache Cassandra CQL - jdbc connection
I hope its not too late but i was able to access Cassandra from soapUIs groovy test step. The below short piece of code does the job but to be able to use this code you should have certain jars (see attached image) in the ext folder. import java.sql.DriverManager; import java.sql.SQLFeatureNotSupportedException; import java.sql.Statement; import javax.sql.DataSource; import org.apache.cassandra.cql.jdbc.*; com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.apache.cassandra.cql.jdbc.CassandraDriver"); def con = DriverManager.getConnection("jdbc:cassandra://localhost:9160/soapuikeyspace"); //keyspace has to be in lowercase def stmt = con.createStatement(); //add data def qry = "insert into users (user_id, lname, fname) values (1747,'Abhishek','Asthana');" def rs = stmt.executeUpdate(qry) For anyone interested, i have written a blog about this too at http://abhishekasthana.com/accessing-cassendra-soapui/.11 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.7KViews0likes1Comment- 11 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.4KViews0likes0Comments
Re: asserting special characters
I solved this problem by using script assertion, see code below def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) def responseHolder = groovyUtils.getXmlHolder( messageExchange.responseContent ) def custName = responseHolder.getNodeValue("//response/*:firstChildNode/*:secondChildNode/*:customerName") assert custName.equalsIgnoreCase(org.apache.commons.lang.StringEscapeUtils.unescapeHtml(context.expand('${#TestSuite#XXXXX}'))) Is there a way to do this using xpath assertion?11 years agoPlace ReadyAPI QuestionsReadyAPI Questions970Views0likes0CommentsRe: asserting special characters
The response xml contains customer name as Abhishek & Asthana I need to extract this value and compare it against what is in the datasheet. The datasheet has the value Abhishek & Asthana in the data sheet. I tried using the below code to unescape the string but the keyword was not recognized. StringEscapeUtils.unescapeHtml(//response/*:firstChildNode/*:secondChildNode/*:customerName) XPathContains assertion failed for path [StringEscapeUtils.unescapeHtml(//response/*:firstChildNode/*:secondChildNode/*:customerName)] : RuntimeException:net.sf.saxon.trans.XPathException: XPath syntax error at char 105 in {...dChildNode/*:customerName}: Unknown system function StringEscapeUtils.unescapeHtml()11 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.3KViews0likes0CommentsRe: Application crash
Could you please provide additional information like... OS version, bit what else was running at that time, maybe a process list along with memory utilization. RAM OS error logs soapUI error logs. Sorry if i am asking more questions than answering them, its bery difficult to watch a video and say why soapUI crashed. The additional information will assist in debuging the problem. Also, does it happen all the time?11 years agoPlace ReadyAPI QuestionsReadyAPI Questions840Views0likes0CommentsRe: LoadUI.bat file missing
when you install loadui along with soapUI two separate folders are created under the smartbear folder one for soapui and another for loadui. Is your loadui folder present? If not then loadUI probably didn't get installed. If loadui is present and/or installed in a directory different from what i mentioned above locate its bat file and in soapUI there is a tab under preferences where you could provide the absolute path to the loadui bat file and you should be all set.11 years agoPlace ReadyAPI QuestionsReadyAPI Questions1KViews0likes0Comments