This blog is really helping a lot, let me check weather my problems also get clear here,ġ. Res = sql.execute( “SELECT * FROM TABLE1 WHERE COL1=’123′” ) (Please feel free to get back if u have any trouble…as I’m just a mail away…leave a comment otherwise) Then,ġ) Import in the Groovy Step, by includingĢ) Then get the required arguments for Sql.getInstance() method, and fetch the sql instance byĭef sql = Sql.newInstance(dbPath, dbUserName, dbPassword, dbDriverName) Ĭhoice of newInstance() method could be as per the options developer has.ģ) Use this sql object for executing the queries to perform operation on DB, for example The pre-setup for this would be placing the required jars for DB connectivity in lib folder of SOAP UI and setting their paths to the CLASSPATH variable in bin/soapui.bat file. (In case of DB2 connection, we need to place db2jcc.jar and db2jcc_license_cu.jar jars inside lib directory and set their paths to CLASSPATH variable in soapui.bat file of bin directory). Say if we use the generic method getInstance(url, user, pwd, driverName) to get the instance and thence execute some SQL queries, we could proceed this way:

This link refers to the Sql class’s API which is used to get the connection

Its simple, basically we will get an sql instance first using parameters like JDBC connection URL, driver class name etc. So how do we get a connection of DB2 database (for that matter any database) using Groovy in SOAP UI ? Connecting to DB inside Test Steps for various processes is required most often in any Test Suite.

Groovy jxl api