Contributions
Re: JDBC Request Step in SoapUI not fetching the DB table data
Thanks Mr. Rao This is the Soapui.log Thu Jan 08 18:15:51 IST 2015:ERROR:An error occured [The character ' ' is an invalid XML character], see error log for details This is the Error.log Thu Jan 08 18:18:24 IST 2015:ERROR:java.io.IOException: The character ' ' is an invalid XML character java.io.IOException: The character ' ' is an invalid XML character at org.apache.xml.serialize.BaseMarkupSerializer.fatalError(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.surrogates(Unknown Source) at org.apache.xml.serialize.XMLSerializer.printText(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.characters(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.XMLSerializer.serializeElement(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.XMLSerializer.serializeElement(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.XMLSerializer.serializeElement(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.XMLSerializer.serializeElement(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at org.apache.xml.serialize.BaseMarkupSerializer.serialize(Unknown Source) at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1681) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.<init>(JdbcResponse.java:38) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:334) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:199) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)1.8KViews0likes0CommentsJDBC Request Step in SoapUI not fetching the DB table data
Hi, I wanted to connect to SQL DB through the JDBC step in SoapUI. I have given the Driver, Connection String, Password details correctly , Test Connection is also success getting me a message on dialogue box "The connection successfully Tested". But when a simple query is executed it is not fetching the DB table columns and instead I'm seeing the response like <Results> <ResultSet fetchSize="0"> <Row rowNumber="1"> The Query I have used is a simple Select * from a Table. The query works fine and fetches me table data in the SQL yog but its not fetching me any data in SoapUI . Please help me.1.9KViews0likes5CommentsRe: How to capture Test Case Result(Whether Passed/Failed) ?
Hi nmrao , thanks for the help. I used the following code for achieving this for( r in testRunner.results ) log.info( "TestStep " + r.testStep.name + " finished with status " + r.status ) But this is not resulting any response.1.8KViews0likes0CommentsGet all test step result of a test case
Get all test step result of a test case , I have tried the following code for achieving it for( r in testRunner.results ) log.info( "TestStep " + r.testStep.name + " finished with status " + r.status ) But this code does not get me any result. But came to know from the forums that this code is working for many folks, how to implement this piece of code. Thanks785Views0likes1CommentHow to capture Test Case Result(Whether Passed/Failed) ?
I have a Test suite with 5 Test Cases , On starting the execution based on the color (Red/Green) highlighted we come to know the Test case is failed or passed. How can we capture the particular Test Case result(Whether Passed of Failed) through groovy or any other method. Purpose of this is to prepare a report of the failed and passed Test cases count in a Test suite.2.2KViews0likes2CommentsNew line in Groovy Script.
Hi, I have to mail the Test results after the Test Suite is run. Im using ActiveXObject for opening the outlook mail ready for sending. I've used the below code for this import org.codehaus.groovy.scriptom.ActiveXObject def outlook = new ActiveXObject("Outlook.Application") def oEmail = outlook.CreateItem(0); oEmail.Recipients.Add("vikranth_sanka@xyz.com"); oEmail.Subject = "SmokeTest"; oEmail.HTMLBody = "Smoke Test done successfully in \r\n xyz and pqr Environments."; But the Body of the Mail is still appearing in single line though I have used \r\n. Is there any other way to use new line feature for this.11KViews0likes2Comments- 1.7KViews0likes0Comments