I'm writing some custom complicated procedures that make some queries that return a single result, but I haven't figured out how to parse my query result from the Result object returned by the query.
For example, I have a
Result result = db.execute(query, params). I can see from my
log.info(result.resultAsString()) that the query returns the correct result.
| pf.value | +----------+ | 29480 | +----------+ 1 row
Long pop = (Long) result.columnAs("pf.value").next(); returns an error
java.util.NoSuchElementException: next on empty iterator
How do I get my value out of the Result object?