How to print all the fields in a record

[Siegfried Heintze]

I am trying once again to get this to work and I'm now using Groovy 1.7. I used eclipse 3.6 and the groovy console and got the same results.

Why does line 16 not print out all the columns for that record?
Why does it not print the value of each field? What is it printing, the type?

Here are the first few lines of my output

#cols=17 cols = [EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo]
1 -- Nancy  Davolio 1968-12-08 00:00:00.0 -- 0 : EmployeeID = groovy.sql.GroovyResultSetExtension@d88aa2
2 -- Andrew  Fuller 1952-02-19 00:00:00.0 -- 0 : EmployeeID = groovy.sql.GroovyResultSetExtension@d88aa2

Here is my code that I am running on groovy 1.7:

    
01 import groovy.sql.Sql
02 class select {
03  static main (args){
04   def sql = Sql.newInstance('jdbc:odbc:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=C:\\Program Files\\Microsoft Office\\OFFICE11\\SAMPLES\\Northwind.mdb;DefaultDir=;UID=Admin;PWD=;', null, null, "sun.jdbc.odbc.JdbcOdbcDriver" )
05 
06   def colnams = new ArrayList() 
07   sql.eachRow("SELECT * FROM EMPLOYEES", 
08    {meta-> 
09      for (i in 0..< meta.columnCount) { 
10         colnams << "${meta.getColumnLabel(i+1)}" 
11       } 
12      println "#cols=" + meta.columnCount + " cols = " + colnams 
13    }, 
14    { rec-> 
15      println rec.EmployeeID + " -- ${rec.FirstName}  ${rec.LastName}
${rec.BirthDate} --  " 
16      rec.eachWithIndex { col, idx -> println "$idx : ${colnams[idx]} =
$col"}
17      //rec.eachWithIndex { col, idx -> println        "${colnams[idx]} =
$col"}
18      //for(int i = 1; i < colnams.size(); i++) println " field = "+rec[i]

19      //for(int i = 1; i < colnams.size(); i++) println colnams[i]+" =
"+rec[colnams[i]] 
20     } 
21     ) 
22  }
23 }

[Christophe Verré]

Please tell us when you crosspost the same question in different forums. Check this FAQ.

[Christophe Verré]

I think you'll find an answer here.

[Siegfried Heintze]

Oops! my bad!

Sorry. Yes, I posted this question a year ago and when I still did not get a response a month ago, I posted again and I still have not received a response. As you can see from http://groovy.329449.n5.nabble.com/How-to-display-all-the-fields-in-groovy-Sql-sql-td370614.html I have posted the last two entries with no response.

I have tried the suggestions of the previous posts and I cannot get them to work. I know the information I want is in there

So I am posting here here hoping for a response. I know the row data is in there and I can get it if I hard code the column names. But I want a generic tool. I can print the column names I retrieve from the metadata. The information is there! How do I get the data out of the rec object. They (blackdrag) told me to use the eachrow function and I just cannot get it to work!

Does it work for you?

Thanks,
siegfried