rendered paste bodyimport java.sql.Connectionimport java.sql.DriverManagerimport javax.sql.DataSourceimport groovy.sql.Sqlimport solid.jdbc.SolidDriverclass queryWCS { static void main(args) { Class.forName("solid.jdbc.SolidDriver"); Connection conn = DriverManager.getConnection('jdbc:solid://wcs:1315/lala/lala'); Sql sql = new Sql(conn); String sQuery = "SELECT lrad.lradname as name,lradif.channelnumber as channel,lradif.previouschannelnumber as prevchannel,lradif.powerlevel as power,lradif.lastchannelupdatetime as lastchannelupdatetime " + " FROM LRADIF,lrad where lradif.macaddress=lrad.macaddress and lradif.iftype=2 " + "order by lradif.lastchannelupdatetime"; sql.eachRow(sQuery){ row | println row.name + " " + row.channel + " " + row.prevchannel } }}