Postgres Pro
Downloads
Home   >   mailing lists

Thread: Eager fetch of Array in one tcp connection

Eager fetch of Array in one tcp connection

From
Petr Prikryl
Date:
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

Re: Eager fetch of Array in one tcp connection

From
Maciek Sakrejda
Date:
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.prikryl@gmail.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@centrum.cz
> prikryl@admin24.cz
> www.admin24.cz
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

Re: Eager fetch of Array in one tcp connection

From
Petr Prikryl
Date:
So, I found that JDBC needs some aditional information to determine
delimiter (viva opensource drivers). But it is worst , that JDBC driver
hasn't implemented Array<Bytea> and I must use workaround (using strings).
PP

On 09/11/2010 02:32 AM, Maciek Sakrejda wrote:
> 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.prikryl@gmail.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@centrum.cz
>> prikryl@admin24.cz
>> www.admin24.cz
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>>
>>


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

Re: Eager fetch of Array in one tcp connection

From
Kris Jurka
Date:

On Sat, 11 Sep 2010, Petr Prikryl wrote:

> So, I found that JDBC needs some aditional information to determine delimiter
> (viva opensource drivers). But it is worst , that JDBC driver hasn't
> implemented Array<Bytea> and I must use workaround (using strings).
> PP
>

I'm not sure what you're referring to with Array<Bytea>.  I suppose we
could return byte[][], that seems like a reasonable thing to do.

Kris Jurka