Database Testing using SOAPUI

In this topic I’ll explain how to test database using SOAPUI Freeware. 

  • Create a new Test Suit
  • Create new test case
  • Add new test Step – JDBC Connection

  • It opens this window. 

  • To create a JDBC connection, the user needs to provide valid Driver and Connection String. These parameters are used to identify the type of database and create a connection to use the database.

For these details refer: https://www.soapui.org/docs/jdbc/reference/jdbc-drivers/. For mysql you need to download the connector file while for few other database connections drivers are included with SOPAUI package. Connections needs to be copied into  C:\Program Files (x86)\SmartBear\SoapUI-5.5.0\bin\ext. On MAC you need to copy same into /Applications/SoapUI-5.5.0.app/Contents/java/app/lib.

MySQL Connection string has following syntax:
Jdbc:mysql://[host]:[port]/[database]?[property][=value]

Here, property is the username and password along with other parameters required to connect with a database.

For example,

jdbc:mysql://localhost:8089/xxx_DB?user=root&password=root

  • Test the connection. If successful then can use any SQL to get the data.

Leave a Reply

Your email address will not be published. Required fields are marked *