Forum Discussion

zsousa's avatar
zsousa
Contributor
8 years ago

Extract data from JDSB response

I need help extracting data from a JDBC response using Groovy.

 

I have a generic JDBC Request that I use for all my SQL. The issue is I want to extract the results.

for example. In the example below, I want to extract the values for "person" and "legacy_userid".  The way I need to do it is by providing the name of the column "legacy_userid" and i would get 340579. Is there a way of doing this ?

 

 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<person.person>246544</person.person>
<person.legacy_userid>340579</person.legacy_userid>
</Row>
</ResultSet>
</Results>