irfan27dec
Regular Visitor
Joined 6 years ago
User Profile
User Widgets
Contributions
No such property: Sql for class: Script19
Pre-requisite: I have placed mysql connector jar in soapui lib folder MySQL database has Persons table with few records I have created Groovy script under a test case, below is the script. When I execute I get following error: No such property: Sql for class: Script19 Please suggest. Groovy script: import groovy.sql.Sql.* try{ //Create DB Connection def dbURL = "jdbc:mysql://localhost:3306/testDB" def dbUser = "root" def dbPassword = "root" def driver = "com.mysql.jdbc.Driver" def dbSQL = Sql.newInstance(dbURL,dbUser,dbPassword,driver) //Execute Query def query = "Select * from Persons" dbSQL.eachRow(query){ //log.info "${it.City}"+"-"+"${it.FirstName}" log.info "${it.City}" } }catch(Exception e){ log.info e.getMessage() }finally{ //Close Connection //db.close() }1.7KViews0likes1Comment