Forum Discussion

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...

Community Hero

5 years ago

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

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.