Archive for October 17th, 2008
Operations with sql instance
Posted by: devakara on: October 17, 2008
Groovy provides very robust methods with sql instance to retrieve and manipulate the ResultSet.
There are methods for retrieving the first row, the ResultSet of some sql query, directly executing insert/update/delete queries.
Prerequisite: Obtain sql instance using
import groovy.sql.Sql
def sql = Sql.newInstance(dbpath, dbusr, dbpwd, dbdriver)
Below are some comprehensive examples which use the above sql instance.
firstRow( sqlQuery ) : This method returns the [...]
Tags: DB Insertion in Groovy, DB operations SOAP UI, DB Operations with Groovy, DB Select in Groovy, groovy DB Select, groovy DELETE from database, groovy INSERT into DB, groovy SELECT from database, groovy sql.eachRow(), groovy sql.execute(), groovy sql.firstRow(), sql connection SOAPUI, sql eachRow groovy, sql eachRow() Groovy SOAPUI, sql execute groovy, sql execute() Groovy SOAPUI, sql firstRow groovy, sql firstRow() Groovy SOAPUI, sql methods in Groovy, sql.eachRow() SOAPUI, sql.execute() SOAPUI, sql.firstRow() SOAPUI
Join me at…
Recent Comments