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.
I’m really impressed along with your writing abilities and also with the layout on your weblog. Is that this a paid topic or did you modify it your self? Anyway keep up the excellent high quality writing, it’s uncommon to see a great blog like this one nowadays!