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

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

python - serve multiple gunicorn django instances under nginx ubuntu -

module - Prestashop displayPaymentReturn hook url -