Accessing database connection string from groovy test step

Hello chirangv 

import groovy.sql.*;
import com.eviware.soapui.support.GroovyUtilsPro;


def jdbcConnectionName = "your jdbc name defined in environment configuration page";   //log.info "   jdbcConnectionName=$jdbcConnectionName";
def groovyUtilsPro = new  GroovyUtilsPro(context);
def sqlConnection = groovyUtilsPro.getJdbcConnection(jdbcConnectionName);
def sql = Sql.newInstance(sqlConnection);

def sqlQuery = """
   SELECT colname
   FROM tablename
   WHERE colname = 'something'
""".toString();
log.info "   sqlQuery=$sqlQuery";
dbRows = sql.rows(sqlQuery);
log.info "   dbRows.size()=${dbRows.size()}";
assert dbRows.size() > 0, "Need a row returned but none was... No data found.";
dbRows.each { row ->
   log.info "   row.id=${row.id}";
};