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

8 Dec 2013


      Forget about it.
After replacing postgresql JDBC driver with a new version of it, getArray()
works.


On Sun, Dec 8, 2013 at 1:36 AM, crocket <[email protected]> wrote:
...
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/Jdbc4...
 ?
{{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}}