free seo tool

soapUI JDBC Connections Example

This post is mainly intended to show how can we configure a JDBC connection in soapUI for Oracle Database. 
Double click on the soapUI Project , this will display a set of tabs. Click on the tab "JDBC Connections" and click on the "Adds a new data connection" button. A dialog box like below image will be displayed.

soapUI JDBC Connection

Select the driver Oracle Thin/oracle.jdbc.driver.OracleDriver if you are using Oracle data base for your back end connection. Enter the details and click ok button. This will create a JDBC Connection pointing to the database you just configured. This JDBC connection can be used in the test step JDBC Request and even in Groovy Scripts to fetch the data from data base.
1 comments:
  • kk says:
    April 18, 2016

    can you explain how to connect using service name instead of SID?
    i get connection error

Post a Comment

This is a new website mainly for SOA Testers using soapUI. Let me know your thoughts/ suggestions.