Forum Discussion

Kathryn_O_Malle's avatar
Kathryn_O_Malle
Contributor
14 years ago

"Run Once" in soapUI Runner fails to execute SoapUI testcase

Hi there,

I've now started trying to use loadUI and I've been trying to integrate it with my existing SoapUI project. I add a soapUI runner to a new loadUI project and select the required SoapUI test case. Yet when I use "Run Once" it completes with 1 failure listed. When I run the same testcase in SoapUI directly it runs without any hassle.

Steps to re-create:
1) I've created a new project in loadUI and added a soapUI runner to it.
2) I use Browse to navigate to the required soapUI project
3) I select the desired testsuite and testcase via the dropdowns
4) I've added a Table Log to the Results output of the soapUI runner
5) I've added a Table Log to the Errors output of the soapUI runner
6) I select "Run Once" on the soapUI runner
7) The Completed and Failed counts on the soapUI Runner both increase by 1
8) I've captured the output at this point from the background DOS window of loadUI and attached it to this posting
9) The Results and Errors Table Logs remain blank

I suspect I've done some newbie loadUI / SoapUI integration mistake and hope this is easy / quick to solve.

Many thanks in advance for the help...

Kind regards
Adam

NB:
a) On the loadUI homescreen, I've previously selected Workspace -> Settings -> SoapUI and selected the batch file we use to launch SoapUI

Tool Info:
loadUI 1.0.1
SoapUI 3.6.1

16 Replies

Sort By
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    14 years ago
    Hi Adam,

    judging from the log it seems your project needs the OdbcJdbc driver, please copy this jar (and any other external dependencies) into folder named "ext" under the loadUI folder.

    Also, the reason that you are not getting any entries in the TableLogs is that your test is not running (terminal connections only propagate messages when a test is running). Just start the test and you should get contents in the tablelogs when pressing the Run Once button. (You can temporarily disable any generators via their on-off switches)

    Hope this helps!

    regards,

    /Ole
    eviware.com
  • Kathryn_O_Malle's avatar
    Kathryn_O_Malle
    Contributor
    14 years ago
    Hi there,

    I've tried finding an "ext" folder directly under "\loadUI-1.0.1", but found one under "\loadUI-1.0.1\jre\lib\ext" instead, is this the one you meant?

    We've tried updating the classpath defined in loadUItest.bat to read as:
    set CLASSPATH=.;C:\Adam\eviware\loadUI-1.0.1\jre\lib\ext\;lib/*;C:\Adam\eviware\;C:\Program Files\Java\;C:\Program Files\JavaFX\;


    I've also seen in my SoapUI code where I create the database connections I import the "groovy.sql.Sql" library.

    I've tried running the SoapUI testcase once from loadUI again but unfortunately still no joy...

    I see the following errors listed in the DOS command window:
    ERROR [SoapUI] An error occured [sun.jdbc.odbc.JdbcOdbcDriver], see error log for details
    java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
    Error [SoapUI] An error occured [Cannot invoke method getTestStepByName() on null], see error log for details
    java.lang.NullPointerException: Cannot invoke method getTestStepByName() on null object

    Have I missed something silly? I've not been able to find the OdbcJdbc driver directly, from what I could see on the net its included in the standard RT.jar that is part of the Java JDK.

    Help! (Thanks!)

    Kind regards
    Adam
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    14 years ago
    Hi Adam!

    Hm.. how exactly are you using the JDBC Driver? via a groovy script or a JDBC Connection?

    If the former, please try adding the following statement to your groovy code before using the driver:

    com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( "sun.jdbc.odbc.JdbcOdbcDriver" )

    and if that doesn't help could share your project or give us enough details so we can try to reproduce?

    thanks in advance!

    regards,

    /Ole
    eviware.com
  • Kathryn_O_Malle's avatar
    Kathryn_O_Malle
    Contributor
    14 years ago
    Hi there,

    Okay here goes...

    1) On my XP Professional SP2 2002 SP2 via Control Pannel -> Administrative Tools -> ODBC Data Source Administrator I've defined a User DSN entry for our Access Database using the Microsoft Access Driver (*.mdb, *.accdb)
    2) Within my SoapUI testcases I use Groovy Script steps when getting data from the external Access database
    3) At the start of each Groovy script I have 
    import groovy.sql.Sql

    4) I then define a connection to the external database via
    def sql = Sql.newInstance(context.expand('jdbc:odbc:<ODBC_Datasource_Name>),
                                             context.expand(' '),
                                             context.expand(' '),
                                             "sun.jdbc.odbc.JdbcOdbcDriver")

    5) I then create a results set via
    def res = sql.firstRow("SELECT * FROM [<Access Database view name]....")

    NB: I use an Access Database view instead of directly accessing the underlying database table(s)

    That's pretty much it...
    I will also now try creating a little dummy project doing the above and attach it to the posting. Afraid I can't attach the actual work project due to various issues.

    Kind regards
    Adam
  • Kathryn_O_Malle's avatar
    Kathryn_O_Malle
    Contributor
    14 years ago
    Hi,
    I've been able to create a set of sanitized project files to help reproduce this issue which I've attached to this posting. They are a loadUI project, a SoapUI project, an Access database, and the logfile snapshot when trying to use the "Run Once" button in the loadUI project. You'll need to create an ODBC connection via Adminstrative Tools as described above.

    Hope this helps...

    Kind regards
    Adam
  • Kathryn_O_Malle's avatar
    Kathryn_O_Malle
    Contributor
    14 years ago
    Hi,

    I've also tried adding the extra line of code that you had suggested in your latest posting above. Unfortunately it still does not work. The error log generated is very slightly different. I've attached the updated SoapUI project file and error log to this posting for you.

    Kind regards
    Adam
  • load_tester's avatar
    load_tester
    14 years ago
    I have a similar problem running soapUI TestCase from loadUI. The TestCase works fine in soapUI but fails in loadUI with the following error:

    15:26:28,357 ERROR [SoapUI] An error occured [hermes/JAXBHermesLoader], see error log for details
    java.lang.NoClassDefFoundError: hermes/JAXBHermesLoader
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.util.HermesUtils.addHermesJarsToClasspath(HermesUtils.java:129)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.util.HermesUtils.getHermes(HermesUtils.java:73)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.util.HermesUtils.hermesContext(HermesUtils.java:54)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.util.HermesUtils.getHermes(HermesUtils.java:198)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.HermesJmsRequestTransport.getHermes(HermesJmsRequestTransport.java:198)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.HermesJmsRequestTransport.init(HermesJmsRequestTransport.java:90)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.HermesJmsRequestSendTransport.execute(HermesJmsRequestSendTransport.java:33)
    at com.eviware.soapui.impl.wsdl.submit.transports.jms.HermesJmsRequestTransport.sendRequest(HermesJmsRequestTransport.java:84)
    at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:123)
    at com.eviware.soapui.impl.wsdl.WsdlSubmit.submitRequest(WsdlSubmit.java:76)
    at com.eviware.soapui.impl.wsdl.WsdlRequest.submit(WsdlRequest.java:236)
    at com.eviware.soapui.impl.wsdl.teststeps.WsdlTestRequestStep.run(WsdlTestRequestStep.java:324)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runTestStep(WsdlTestCaseRunner.java:207)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.internalRun(WsdlTestCaseRunner.java:138)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.internalRun(WsdlTestCaseRunner.java:39)
    at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:135)
    at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:812)
    at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:679)
    at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:406)
    at com.eviware.loadui.impl.component.categories.RunnerBase.access$600(RunnerBase.java:65)
    at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:686)
    at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:188)
    at java.lang.Thread.run(Unknown Source)
    15:26:28,404 ERROR [WsdlSubmit] Exception in request: java.lang.NullPointerException
    15:26:28,404 ERROR [SoapUI] An error occured [java.lang.NullPointerException], see error log for details
    java.lang.NullPointerException
    at com.eviware.soapui.impl.wsdl.WsdlSubmit.run(WsdlSubmit.java:130)
    at com.eviware.soapui.impl.wsdl.WsdlSubmit.submitRequest(WsdlSubmit.java:76)
    at com.eviware.soapui.impl.wsdl.WsdlRequest.submit(WsdlRequest.java:236)
    at com.eviware.soapui.impl.wsdl.teststeps.WsdlTestRequestStep.run(WsdlTestRequestStep.java:324)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runTestStep(WsdlTestCaseRunner.java:207)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.internalRun(WsdlTestCaseRunner.java:138)
    at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.internalRun(WsdlTestCaseRunner.java:39)
    at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:135)
    at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:812)
    at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:679)
    at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:406)
    at com.eviware.loadui.impl.component.categories.RunnerBase.access$600(RunnerBase.java:65)
    at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:686)
    at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:188)
    at java.lang.Thread.run(Unknown Source)

    I added hermes-1.14.jar to loadUI/ext folder but it didn't make any difference. What am I missing?
    My TestCase is using HermesJMS to test JMS messages. I'm running loadUI 1.0.1 and soapUI 3.6.1.

    Thank you for your help.
    Irina
  • Kathryn_O_Malle's avatar
    Kathryn_O_Malle
    Contributor
    14 years ago
    Hi Ole,

    Have you hopefully been able to make positive progress with this issue? Getting some heat from my project management over it...
    Thanks.

    Kind regards
    Adam
  • Beno_Iskratel's avatar
    Beno_Iskratel
    Frequent Contributor
    14 years ago
    Kathryn O`Malley wrote:
    Hi there,

    I've tried finding an "ext" folder directly under "\loadUI-1.0.1", but found one under "\loadUI-1.0.1\jre\lib\ext" instead, is this the one you meant?


    don't know if this is still actual... i have had the same problem.

    The solution was:


    Re: Oracle JDBC driver and LoadUI
    by eviware support ยป 01 Dec 2010 12:10

    Hello,

    The correct path to place the SolidDriver jar file into is in <loadui installation>/ext/, so for example, it might be: c:\Program Files\eviware\loadUI-1.0.2-SNAPSHOT\ext\ under Windows. This ext directory doesn't exist by default, so you will probably have to create it. Hope this helps!

    Regards,
    Dain
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    14 years ago
    Hi everyone,

    regarding Adams problem; can you show your entire script? I've created a simple TestCase with a groovy script that just initializes the JdbcOdbcDriver and that seems to work ok. Are you using the nightly build (which has some classpath-related fixes) or the 1.0.1 release?

    Regarding the Hermes problem; Hermes (and thus JMS support) does unfortunately currently not work in loadUI, we hope to have that resolved in a future release.

    kind regards,

    /Ole
    eviware.com