Forum Discussion

praneeth12's avatar
praneeth12
Occasional Contributor
5 years ago

JDBCrequst from groovy script,After successful connection and query executed.How to set response .

//query executed from script def con = Sql.newInstance("jdbc:oracle:thin:@vXXX:XXX", "XXX", "XXX", "oracle.jdbc.driver.OracleDriver") //Sucessfully Connected Database def respId = con.rows("SELECT...
HimanshuTayal's avatar
HimanshuTayal
Community Hero
5 years ago

praneeth12 : I am not getting what error you are facing could you please elaborate where have you stuck.

  • praneeth12's avatar
    praneeth12
    Occasional Contributor
    5 years ago

    licNum = con.rows("SELECT * from LICENSE where LICENSE_NUMBER='564767' ")

    I am getting data from data base all column values with below format useing jdbcRequst from groovy.

    [{LICENSE_ID=421, IS_ACTIVE=1,  LICENSE_CLASS_ID=1, APPROVED_EVENT_DATE=null}]

    how to Set above Name and values to properties.

    • HimanshuTayal's avatar
      HimanshuTayal
      Community Hero
      5 years ago

      praneeth12 :

       

      If it is a array then you can use:

       

      arrSize = licNum.size();

      for(int i= 0 ; i < arrSize ; i++){

      if(i==0){

      testRunner.testCase.getTestStepByName("Properties").setPropertyValue("LICENSE_ID",licNum[i])

      }

      else if(i == 1){

      testRunner.testCase.getTestStepByName("Properties").setPropertyValue("IS_ACTIVE",licNum[i])

      }

      }

      likewise, hope it will resolve your issue 🙂