Dynamic query, temp table, insert select
Hi, I went thru this older post https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621 And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting <Results> <UpdateCount>0</UpdateCount> </Results> Although, I expect the output of my Select query which is my last statement. I can see it use to be a bug in earlier version. Not sure if that is still an issue, or am I missing something. Thanks in advance. P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio) Regards, Andy
JDBC request is failing ramdomly
Hi All! I hope you can help me. I created a test case with this test steps: I created a JDBC test step (check document status) with a query that checks that the document was created successfully in the database, but sometimes when I ran the test it fails, not always. I thought that if I execute the same query but in a Groovy script (check document status 2) it might work but the same thing is happening. If I ran manually the step that fail it works. What could be happening? Thanks in advance!
JDBC like statement
Hi community, I've been struggling with this issue for some time now but I found some workarounds, but now I need it and can't really find a good answer for me. I need to use in a jDBC query the 'like' statement and with all combos I could think of or find I always end up in an error. So select * from frc where service like 'CLI%' works out fine, the problem might be that I use a property in this query so it's select * from frc where service like :ser% (I've tried * and ? , and even '%') any ideas or hints ? Thnx in advance
IO Error: Unknown host specified in TestRunner Execution
Hello, We have some Test Steps that make use of JDBC connections in SoapUI. For our Oracle database we use a tnsnames.ora file to manage the hosts and connections. I did have some initial problems getting that to work with SoapUI. But finally got it after updating some things in the vmoptions file and moving the odbc driver into <Install Directory>\SmartBear\ReadyAPI-1.6.0\bin\ext. It works fine now. However, I noticed when we try to run the tests from the cmd line or Test Runner they fail. How can I configure SoapUI to know that the hosts are there? Just making a simple connection step and running a query here. Sample from the error log: 09:35:58,004 ERROR [SoapUI] An error occurred [IO Error: Unknown host specified ], see error log for details 09:35:58,005 ERROR [errorlog] java.sql.SQLRecoverableException: IO Error: Unknown host specified java.sql.SQLRecoverableException: IO Error: Unknown host specified at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:517) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:557) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:233) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:556) at com.eviware.soapui.support.GroovyUtils$DriverProxy.connect(GroovyUtils.java:150) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:67) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.getDatabaseConnection(JdbcSubmit.java:188) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:214) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:171) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:145) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.<init>(JdbcSubmit.java:77) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcRequest.submit(JdbcRequest.java:133) at com.eviware.soapui.impl.wsdl.teststeps.JdbcRequestTestStep.run(JdbcRequestTestStep.java:203) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:251) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:50) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:161) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:127) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.start(AbstractTestRunner.java:73) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCase.run(WsdlTestCase.java:673) at com.eviware.soapui.impl.wsdl.WsdlTestCasePro.run(WsdlTestCasePro.java:96) at com.eviware.soapui.impl.wsdl.WsdlTestCasePro.run(WsdlTestCasePro.java:85) at com.smartbear.ready.cmd.runner.SoapUITestCaseRunner.runTestCase(SoapUITestCaseRunner.java:633) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.runTestCase(SoapUIProTestCaseRunner.java:237) at com.smartbear.ready.cmd.runner.SoapUITestCaseRunner.runRunner(SoapUITestCaseRunner.java:430) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.runRunner(SoapUIProTestCaseRunner.java:98) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.run(AbstractSoapUIRunner.java:257) at com.smartbear.ready.cmd.runner.AbstractSoapUIRunner.runFromCommandLine(AbstractSoapUIRunner.java:160) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.init(SoapUIProTestCaseRunner.java:82) at com.smartbear.ready.cmd.runner.pro.SoapUIProTestCaseRunner.main(SoapUIProTestCaseRunner.java:78) Caused by: oracle.net.ns.NetException: Unknown host specified at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:188) at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:130) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:413) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:882) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:267) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1625) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:365)
How can i connect oracle SQL developer connection without entering "sid".
Please find the attached screenshot as well for reference. The problem i am facing is ..while connecting Oracle sql developer I am entering service name and keeping the 'SID' field blank(which is not mandatory field in the tool). But in ReadyAPI(Please find the attached screenshot) sid is a mandatory field, i can not keep it blank while connecting. Hence i am getting error "Can't get the Connection for specified properties; java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection"
