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

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 🙂