Forum Discussion

charsnonumber's avatar
charsnonumber
New Contributor
12 years ago

[Res] DB Connection string is not updated when changing env

Hi, I'm running 4.5.2 (PRO) on Windows 7 PC. There is a problem when switchning between environments. The DataBase (DB2) connections are not changed. The user must run each test step that cont...
SiKing's avatar
SiKing
Community Expert
12 years ago
I take that back: there is still a problem! I am not sure exactly where the problem is though.


  1. create a project

  2. create a JDBC connection

  3. create an Environment

  4. create a test that used the JDBC connection

  5. verify everything is working, save everything, exist SoapUI (just in case)

  6. create another Environment

  7. run the testcase against this new environment

  8. the JDBC step never gets executed, the testcase stops at that point with the below errors

  9. the workaround that I have found: you need to open and close every single JDBC step 



    10. 2013-11-01 13:10:46,913 INFO  [SoapUIProTestCaseRunner] Running soapUI testcase [createClientKey TestCase]
    2013-11-01 13:10:46,913 INFO  [SoapUIProTestCaseRunner] running step [check validateHash]
    2013-11-01 13:10:47,283 INFO  [SoapUIProTestCaseRunner] Assertion [Not SOAP Fault] has status VALID
    2013-11-01 13:10:47,283 INFO  [SoapUIProTestCaseRunner] Assertion [EXISTS validateHash] has status VALID
    2013-11-01 13:10:47,283 INFO  [SoapUIProTestCaseRunner] running step [retrieve appSignatureHash]
    2013-11-01 13:10:49,723 ERROR [SoapUI] An error occured [Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.], see error log for details
    2013-11-01 13:10:49,723 ERROR [errorlog] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350)
     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)
     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
     at com.eviware.soapui.support.GroovyUtils$DriverProxy.connect(GroovyUtils.java:171)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:68)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.getDatabaseConnection(JdbcSubmit.java:218)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:261)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:197)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.<init>(JdbcSubmit.java:75)
     at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcRequest.submit(JdbcRequest.java:135)
     at com.eviware.soapui.impl.wsdl.teststeps.JdbcRequestTestStep.run(JdbcRequestTestStep.java:205)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:239)
     at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:48)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:148)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:43)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:135)
     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.net.UnknownHostException: unused
     at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
     at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
     at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
     at java.net.InetAddress.getAllByName0(Unknown Source)
     at java.net.InetAddress.getAllByName(Unknown Source)
     at java.net.InetAddress.getAllByName(Unknown Source)
     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:249)
     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
     ... 34 more
    2013-11-01 13:10:49,793 INFO  [SoapUIProTestCaseRunner] Assertion [JDBC Status] has status UNKNOWN
    2013-11-01 13:10:49,793 INFO  [SoapUIProTestCaseRunner] Assertion [VERIFY md5] has status UNKNOWN
    2013-11-01 13:10:49,793 ERROR [SoapUIProTestCaseRunner] retrieve appSignatureHash failed, exporting to [C:\Users\XXX\workspace\das-war-test\soapui\results\DeviceAuth_Smoke_TestSuite-createClientKey_TestCase-retrieve_appSignatureHash-0-FAILED.txt]
    2013-11-01 13:10:49,803 ERROR [SoapUIProTestCaseRunner] Error saving failed result: java.lang.NullPointerException
    java.lang.NullPointerException
     at java.io.StringReader.<init>(Unknown Source)
     at org.apache.xmlbeans.impl.store.Locale.parse(Locale.java:708)
     at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:696)
     at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:683)
     at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:208)
     at org.apache.xmlbeans.XmlObject$Factory.parse(XmlObject.java:580)
     at com.eviware.soapui.support.xml.XmlUtils.createXmlObject(XmlUtils.java:263)
     at com.eviware.soapui.support.XmlHolder.<init>(XmlHolder.java:38)
     at com.eviware.soapui.impl.wsdl.teststeps.JdbcTestStepResult.writeTo(JdbcTestStepResult.java:224)
     at com.eviware.soapui.tools.SoapUITestCaseRunner.afterStep(SoapUITestCaseRunner.java:722)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:251)
     at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:48)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:148)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:43)
     at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:135)
     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    2013-11-01 13:10:49,823 INFO  [SoapUIProTestCaseRunner] Finished running soapUI testcase [createClientKey TestCase], time taken: 2870ms, status: FAILED


    I have a new environment, but no workaround for this.