Eager fetch of Array in one tcp connection - Mailing list pgsql-jdbc

Good day,
I'm trying to fetch Array in one row. SQL works well, but when I tried
to convert org.postgresql.jdbc4.Jdbc4Array to java Array :
allowedMAC = (List<byte[]>)  mac.getArray();

I'm getting exception below.
This exception is maybe caused by closed connection by
org.springframework.jdbc.core.JdbcTemplate .

I tried to find out, how to fetch this org.postgresql.jdbc4.Jdbc4Array
directly (I have much rows in result and a need to retrieve everything
in one question), but function is trying to connect do DB.
How should I fetch everything in one select, am I able to disable those
"re-question"?
Thanks a lot
PP




Sep 11, 2010 1:00:07 AM cz.admin24.shdb.db.DAO.SwitchportConfig <init>
SEVERE: null
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
         at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
         at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
         at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
         at
org.postgresql.jdbc2.TypeInfoCache.getArrayDelimiter(TypeInfoCache.java:335)
         at
org.postgresql.jdbc2.AbstractJdbc2Array.buildArrayList(AbstractJdbc2Array.java:165)
         at
org.postgresql.jdbc2.AbstractJdbc2Array.getArrayImpl(AbstractJdbc2Array.java:138)
         at
org.postgresql.jdbc2.AbstractJdbc2Array.getArray(AbstractJdbc2Array.java:110)
         at
cz.admin24.shdb.db.DAO.SwitchportConfig.<init>(SwitchportConfig.java:46)
         at
cz.admin24.shdb.db.DAO.AccessConfigDAOBean.getPortConfigFromDB(AccessConfigDAOBean.java:129)
         at
cz.admin24.shdb.db.DAO.AccessConfigDAOBean.getAllRequestedUpdates(AccessConfigDAOBean.java:92)
         at
cz.admin24.shdb.network.ciscoconf.AccessConfigurator.updateSwitchsports(AccessConfigurator.java:59)
         at cz.admin24.shdb.network.ciscoconf.App.doUpdate(App.java:38)
         at cz.admin24.shdb.network.ciscoconf.App.main(App.java:66)
Caused by: java.io.IOException: Stream closed
         at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:26)
         at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:121)
         at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212)
         at org.postgresql.core.PGStream.flush(PGStream.java:507)
         at
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1107)
         at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
         ... 12 more

--
Petr Prikryl
-----------------------
petrprikryl@centrum.cz
prikryl@admin24.cz
www.admin24.cz