New subject: [xwiki-users] How do I iterate JDBC arrays in groovy macros?

7 Dec 2013

The below snippet results in
"org.postgresql.jdbc4.Jdbc4Array.getArrayImpl(long,int,Map) is not yet
implemented." Does anyone know how to iterate
http://jdbc.postgresql.org/development/privateapi/org/postgresql/jdbc4/Jdbc…
 ?

{{groovy}}
println "|=Firewalled|=Port|=Protocol|=Service|=Application|=Description"

import groovy.sql.Sql
sql = Sql.newInstance( 'jdbc:postgresql:machine_info?user=machine_info' )
sql.eachRow( 'select * from network_service' ) {
  if(it.firewalled) {
    firewalled="Yes"
  } else {
    firewalled="No"
  }

  p=""
  for(proto in it.protocols.getArray(null)) {
    p+=proto + ","
  }

  println
"|$firewalled|$it.port|$p|$it.service|$it.application|$it.description"
}
{{/groovy}}