Automation, DataBase Testing, Quality Analyst, Services Testing, SoapUI, Web Services, Web Testing

SoapUI Tutorial Part 4 : Effectively using JDBC connections and databases in SoapUI

In today’s world , if you are a tester, QA , developer or a UI developer , you can not escape from data. Data is everywhere on web ,in real life , in our computer , in mobile phones , in Television , in books , in files , in banks , everywhere. And as data is getting increased storing them has also became a crucial topic to discuss about.

We have seen many companies running so as to manage data from various tools and techniques like Hadoop, Big Data , etc.

db

How to manage various databases in SoapUI?

SoapUi provides a way via which you can add different type of databases in your project. And further use them in your tests. SoapUI provides support for multiple databases like postgres ,db2 , mysql , oracle, sybase , etc.

Pre-requisite:

You need to download jars for the database you want to work with.

DataBaseDriversLocation

And then you have to place that jar to the ext folder of SoapUI {\SmartBear\SoapUI-Pro-5.0.0\bin\ext}.Once this is done then only you can avail all the services of SoapUI JDBC connection.

Adding JDBC connection

  • Double click on your project.
  • You can see different tabs in the editor section, click on JDBC Connection tab.

JDBC_Connections.PNG

 

  • And then click on the first icon of  ‘+’ , via this you can add new database connection in your project.Once you click on this a new window will pop-up where-in you can give a logical name of your database connection.

JDBC_Connection_Step1

  • Next you have to mention further details of the connection you want to connect with , like
  1. Driver name
  2. User name
  3. Password
  4. Database connection string

JDBC_Step2

 

  • And hence forth the Test Connection button will get enable and you can test your connection whether the connection is successfully made or not. Before that make sure you have gone through the checklist :
  1. Driver is added successfully at the correct position
  2. You have restarted SoapUI ,after the addition of driver.
  3. If you are working with local databases then database service is up and running.
  4. You have selected the right driver in SoapUi window.

Once this is done , you can execute different queries in your project and play around with the world of databases.

Advertisements

1 thought on “SoapUI Tutorial Part 4 : Effectively using JDBC connections and databases in SoapUI”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s