groovy - Issue in SOAP UI with SQL using Grovvy Script, the working code stopped working -
i hitting db2 database using grovvy scripts in soapui, below code working fine me sometime. not working , stuck , unable find solution
the query:select column_id table_name column_timestamp > '2016-10-26 05:37:22'
below code
def sqlquerypopid = "select column_id table_name column_timestamp>'2016-10-26 05:37:22'" def popid **// code not entering in below loop, working fine day back, not sure 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 giving below error
error:
wed oct 26 05:37:58 edt 2016:info:groovy.lang.missingmethodexception: no signature of method: groovy.sql.sql.query() applicable argument types: (java.lang.string) values: [select column_id table_name 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 me went wrong current code working fine, somehow stopped working
Comments
Post a Comment