Forum Discussion

StevenC's avatar
StevenC
Contributor
11 years ago

Writing load test results to a database

My tests generate a unique id that goes in with each soap call and flows through our system what I am trying to solve for is to be able to run a load test and say the soap response time for transaction id number abc123 was x.xx seconds, that way for any transactions which exceeded a given threshold we can investigate in log files and the database to see where the problem was occurring.

The obvious solution to this is to have a groovy step after the soap call that writes the unique id and response time (and possibly some other data that would be useful to me) off to a database but I've spent the better part of the last 2 days reading your online documentation and googling and I see that this can be done but I have not been able to find any examples how to do it or even any documentation that tells me what class/property holds the response time for the soap call.

So can someone provide me with an example?

4 Replies

  • Sorry Rao but you either didn't read or didn't understand my question.

    I don't care if the test passed and therefore neither of your links are of any help.

    What I am looking for is to be able to write out the transaction response time to a database

    See the quick tip on this page...

    http://www.soapui.org/Load-Testing/expo ... stics.html

    soapUI Pro Event Handlers allow you collect and process data collected during LoadTests in any way you want, for example you might want to write all results to a database for detailed analysis. Check them out at ...


    Well this is EXACTLY what I want to do, the problem is "..." doesn't help me and when I've looked around at your event handler pages none of them give me any info on how to do this
  • nmrao's avatar
    nmrao
    Community Hero
    Well, what does the line 14 of second link says ??
    log.info "Status: $runner.status, time taken for TestCase was: $runner.timeTaken ms"

    Is not " $runner.timeTaken" that you looking for? Ignore what you are not interested in.
  • nmrao's avatar
    nmrao
    Community Hero
    Or is that you want to take time only for particular step, would be nice if specific details available in the desciption.