SoapUI: JDBC Step example

Follow these steps to prepare your first jdbc step in SoapUI

1) Copy & paste the oracle driver jar file in SoapUi’s lib directory
2) Create a jdbc step

example configuration of the newly created jdbc step as follows :

a) Driver: oracle.jdbc.driver.OracleDriver
b) Connection String: jdbc.oracle.thin:hr/hr@127.0.0.1:1521:XE

Write your query string “select * from departments”

Add assertion with “contains”

Run your step and observe!

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