From: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
---|---|
To: | Petr Prikryl <peter(dot)prikryl(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Eager fetch of Array in one tcp connection |
Date: | 2010-09-11 00:32:57 |
Message-ID: | AANLkTi=qTrVEqAqQNbmuxpWtKgS65cigGoOeV5_hG61e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
What does the server log say?
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
On Fri, Sep 10, 2010 at 4:53 PM, Petr Prikryl <peter(dot)prikryl(at)gmail(dot)com> wrote:
> 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(at)centrum(dot)cz
> prikryl(at)admin24(dot)cz
> www.admin24.cz
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thiago Godoi | 2010-09-11 03:04:47 | Re: Send a command to postgres and close the program |
Previous Message | Petr Prikryl | 2010-09-10 23:53:16 | Eager fetch of Array in one tcp connection |