Forum Discussion

bendg25's avatar
bendg25
16 years ago

Can SOAPUI do this...

I would like to run a test (to a Webservice), then get a DB connection (and we have lots of developers, so we need to be able to change the db url to point to user specific databases) and execute some SQL to validate certain rows have been inserted into a DB table, and validate certain field values are in there...

or am I better off writing a load of JUnit java tests to do this?

Any advice appreciated!!

2 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi!

    why certainly :-)

    Set up a TestCase with a SOAP Request that does the WebService call and then a JDBC TestRequest Step to validate the database. You can paramerize the connection-parameters and query as you like to make it easy to switch databases, etc..

    Hope this helps!

    regards,

    /Ole
    eviware.com
  • Equinix_Inc_Sup's avatar
    Equinix_Inc_Sup
    Occasional Contributor
    15 years ago
    I dont find any where an exaple to externalize the JDBC connection parameteres.If you can provide the example assuming that my data base connection properties are at test suite level that will help me a lot.