soapUI JDBC Connection configuration settings using groovy Script

In soapUI Pro, there is an option to configure a JDBC database connection and it can be accessed in many places like DataSource test step, JDBC Request step, DataSink step etc. But in some cases, we might need to get the same JDBC connection object and connection details in groovy script as well. In this post we will take a quick look on how can we get the JDBC connection properties in groovy script editor (Script test step).

• First of all, double click on your project on the left side pane of soapUI.
• Now, navigate to the tab "JDBC Connections" on the right side pane.
• Click on the plus sign and provide the necessary details and configure the database connection.
• Name the connection as "JDBCTest1" (we will be referring this JDBC connection later on the groovy script.)
• Test the JDBC connection before closing the dialog box.

Now use the below code to create a connection object and get the properties to use it in groovy script.import groovy.sql.Sql;
// Below line will create an object of the already created JDBC connection.
def ConObj = context.testCase.testSuite.project.databaseConnectionContainer.getDatabaseConnectionByName('JDBCTest1');
//Below line is using the connection String from already created JDBC connection.
def Con = Sql.newInstance(ConObj.getConnectionString());
def res = Con.rows("select *from tablename;");
Con.close();