How to read each row in a groovy-sql statement?

Question

I am trying to read a table having five rows and columns. I have used sql.eachRow function to read eachRow and assign the value to a String. I am getting an error "Groovy:[Static type checking] - No such property: MachineName for class: java.lang.Object"

My code:

sql.eachRow('select * from [MACHINES] WHERE UpdateTime > :lastTimeRead, [lastTimeRead: Long.parseLong(lastTimeRead)])
{ row ->
    def read = row.MachineName
}

but MachineName is my column name. How can i overcome this error.

Have you tried column name with lower case like `row.machinename` — Bhanuchander Udhayakumar, Apr 26 '18 at 11:33

score 1 · Accepted Answer · answered Apr 26 '18 at 11:32

Using dynamic Properties with static type checking is not possible*.

However, eachRow will pass a GroovyResultSet as first parameter to the Closure. This means that row has the type GroovyResultSet and so you can access the value using getAt

row.getAt('MachineName')

should work. In groovy you can also use the []-operator:

row['MachineName']

which is equivalent to the first solution.

*) without a type checking extension.

score 0 · Answer 2 · answered Apr 27 '18 at 09:41

If you Know the Column name you can just use the Below.

"$row.MachineName"

But if you don't Know column name or having some issue, still it can be accessed using an array of Select.

sql.eachRow('select * from [MACHINES] WHERE UpdateTime > :lastTimeRead, [lastTimeRead: Long.parseLong(lastTimeRead)]) 
{ row->
        log.info "First value = ${row[0]}, next value = ${row[1]}"
}

How to read each row in a groovy-sql statement?

2 Answers2