Issue in SOAP UI with SQL using Grovvy Script
I am hitting DB2 database using grovvy scripts in SOAPUI, the below code was working fine for me for sometime. However suddenly its not working and I am stuck and unable to find a solution The query:SELECT Column_ID FROM Table_Name where Column_TIMESTAMP>'2016-10-26 05:37:22' Below is the code def sqlQueryPopID = "SELECT Column_ID FROM Table_Name where Column_TIMESTAMP>'2016-10-26 05:37:22'" def popID // The code is not entering in the below loop, however was working fine a day back, not sure what happened sqlITOD.query(sqlQueryPopID) {resultSet -> while (resultSet.next()) { popID = resultSet.getString(1) log.info("Popultauin ID is:"+popID) } }//end of result set log.info("The Sql Query:"+sqlITOD.query(sqlQueryPopID) )//This line is giving below Error ERROR: Wed Oct 26 05:37:58 EDT 2016:INFO:groovy.lang.MissingMethodException: No signature of method: groovy.sql.Sql.query() is applicable for argument types: (java.lang.String) values: [SELECT Column_ID FROM Table_Name where Column_TIMESTAMP>'2016-10-26 05:37:22'] Possible solutions: query(java.lang.String, groovy.lang.Closure), query(groovy.lang.GString, groovy.lang.Closure), query(java.lang.String, java.util.List, groovy.lang.Closure), query(java.lang.String, java.util.Map, groovy.lang.Closure), query(java.util.Map, java.lang.String, groovy.lang.Closure), every() Please help me what went wrong as the current code was working fine, somehow it stopped working