Forum Discussion

praneeth12's avatar
praneeth12
Occasional Contributor
4 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

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

praneeth12's avatar
praneeth12
Occasional Contributor
4 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
    4 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 🙂