Contributions
Re: Unable to connect to jdbc oracle after soapui test
Hi, Thanks for the reply. Please find the overall picture. Iam having issue in Test 3. Test 1 a)Run the query in oracle database - Sucess Test 2 b)Run the soap ui test through bat file - Sucess Test 3 a)Run the soap ui test through bat file - Sucess b)Run the query in oracle database - Failing due to jdbc error. Hence i feel that after soapui performs the test, it is not allowing the jdbc connection to oracle database.1.6KViews0likes1CommentUnable to connect to jdbc oracle after soapui test
Hi, Iam running soapui test through java code and after it is completed, Iam connecting to the oracle connection through jdbc oracle driver. But iam getting "Connection timedout " error . The same connection is working without calling soapui test. I assume that previous soapui connection does not allow the jdbc oracle connection. please let me know if you have any solution. Please find the detailed log. FAILED: driver java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.ibmhq.GetDBFirstColRecord.execute(GetDBFirstColRecord.java:60) at com.ibmhq.hqdriver.selectaction(hqdriver.java:614) at com.ibmhq.hqdriver.driver(hqdriver.java:433) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86) at org.testng.internal.Invoker.invokeMethod(Invoker.java:643) at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820) at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128) at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129) at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112) at org.testng.TestRunner.privateRun(TestRunner.java:782) at org.testng.TestRunner.run(TestRunner.java:632) at org.testng.SuiteRunner.runTest(SuiteRunner.java:366) at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361) at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319) at org.testng.SuiteRunner.run(SuiteRunner.java:268) at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244) at org.testng.TestNG.runSuitesLocally(TestNG.java:1169) at org.testng.TestNG.run(TestNG.java:1064) at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:114) at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251) at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292) ... 33 more Caused by: java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:363) at java.net.Socket.connect(Socket.java:589) at java.net.Socket.connect(Socket.java:538) at java.net.Socket.<init>(Socket.java:434) at java.net.Socket.<init>(Socket.java:211) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127) at oracle.net.nt.ConnOption.connect(ConnOption.java:126) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306) ... 38 more1.6KViews0likes3CommentsHelp on SOAPUITestrunner
Hi, I have an soapui xml which runs throughtoolrunner sucessfully in soapui tool.(Run button after selecting test case) I am trying to execute the same xml in java through eclipse. Iam using the class SoapUIToolRunner for this and getting an error forjava.lang.NullPointerException. I think it is because interface and tool is not set in soapuitoolrunner. Can you please let me know how to set interface and tool in soapuitoolrunner class. If possible any sample code. ------------------ Code used for soapuitoolrunner SoapUIToolRunner SoapUIToolRunner = new SoapUIToolRunner(); SoapUIToolRunner.setProjectFile(projectfile); SoapUIToolRunner.setProjectProperties(soapprop); SoapUIToolRunner.run(); ----- Error log 17:33:23,045 INFO [DefaultSoapUICore] All plugins loaded 17:33:25,526 INFO [WsdlProject] Loaded project from [file:/C:/..../medicareSupplier-soapui-project.xml] 17:33:25,544 INFO [SoapUIToolRunner] Running tools [null] for interface [null] in project [medicareSupplier] java.lang.NullPointerException576Views0likes0CommentsRe: Connection timed out: connect in SoapUIMultiThreadedHttpConnectionManager
Same test is getting executed perfectly in SOAPUI. This soap test uses basic authentication set up in soapui tool and saved in xml. When the same xml is executed through soapuitestcaserunner, iam getting the error message as timeout. 2018-10-24 17:45:48,836 INFO [SoapUITestCaseRunner] running step [Properties] 2018-10-24 17:45:48,908 INFO [SoapUITestCaseRunner] running step [CMRMAProcessor - ACCEPTEDTRANSACTIONACKNOWLEDGEMENT] 2018-10-24 17:46:10,151 ERROR [WsdlSubmit] Exception in request: org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect 2018-10-24 17:46:10,153 ERROR [SoapUI] An error occurred [Connect to 10.226.11.124:6500 failed: Connection timed out: connect], see error log for details 2018-10-24 17:46:10,155 ERROR [errorlog] org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect at com.eviware.soapui.impl.wsdl.support.http.SoapUIMultiThreadedHttpConnectionManager$SoapUIClientConnectionOperator.openConnection(SoapUIMultiThreadedHttpConnectionManager.java:279) at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:144) at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:134) at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:610) at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:445) at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:835) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56) 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:290) at com.eviware.soapui.impl.wsdl.submit.transports.http.HttpClientRequestTransport.sendRequest(HttpClientRequestTransport.java:220) at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:119) at com.eviware.soapui.impl.wsdl.WsdlSubmit.submitRequest(WsdlSubmit.java:79) at com.eviware.soapui.impl.wsdl.WsdlRequest.submit(WsdlRequest.java:217) at com.eviware.soapui.impl.wsdl.teststeps.WsdlTestRequestStep.run(WsdlTestRequestStep.java:364) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:211) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:138) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:46) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:129) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.start(AbstractTestRunner.java:77) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCase.run(WsdlTestCase.java:595) at com.eviware.soapui.tools.SoapUITestCaseRunner.runTestCase(SoapUITestCaseRunner.java:555) at com.eviware.soapui.tools.SoapUITestCaseRunner.runRunner(SoapUITestCaseRunner.java:387) at com.eviware.soapui.tools.AbstractSoapUIRunner.run(AbstractSoapUIRunner.java:188) at com.ibmhq.SoapUI.execute(SoapUI.java:54) at com.ibmhq.hqdriver.selectaction(hqdriver.java:734) at com.ibmhq.hqdriver.driver(hqdriver.java:433) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86) at org.testng.internal.Invoker.invokeMethod(Invoker.java:643) at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820) at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128) at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129) at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112) at org.testng.TestRunner.privateRun(TestRunner.java:782) at org.testng.TestRunner.run(TestRunner.java:632) at org.testng.SuiteRunner.runTest(SuiteRunner.java:366) at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361) at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319) at org.testng.SuiteRunner.run(SuiteRunner.java:268) at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244) at org.testng.TestNG.runSuitesLocally(TestNG.java:1169) at org.testng.TestNG.run(TestNG.java:1064) at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:114) at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251) at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77) Caused by: java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:121) at com.eviware.soapui.impl.wsdl.support.http.SoapUIMultiThreadedHttpConnectionManager$SoapUIClientConnectionOperator.openConnection(SoapUIMultiThreadedHttpConnectionManager.java:262) ... 52 more1.7KViews0likes0CommentsConnection timed out: connect in SoapUIMultiThreadedHttpConnectionManager
Hi, when trying to execute a soapui test throughSoapUITestCaseRunner in eclipse, iam getting this error. The same is executing fine through soap ui application. Please let me know the solution. Please find the detailed log. 2018-10-24 17:46:10,151 ERROR [WsdlSubmit] Exception in request: org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect 2018-10-24 17:46:10,153 ERROR [SoapUI] An error occurred [Connect to 10.226.11.124:6500 failed: Connection timed out: connect], see error log for details 2018-10-24 17:46:10,155 ERROR [errorlog] org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect org.apache.http.conn.HttpHostConnectException: Connect to 10.226.11.124:6500 failed: Connection timed out: connect at com.eviware.soapui.impl.wsdl.support.http.SoapUIMultiThreadedHttpConnectionManager$SoapUIClientConnectionOperator.openConnection(SoapUIMultiThreadedHttpConnectionManager.java:279)1.8KViews0likes1Comment