Re: JDBC Binary transfer of Arrays - Mailing list pgsql-general

From bubba postgres
Subject Re: JDBC Binary transfer of Arrays
Date
Msg-id BANLkTimmR9-JJR6Rj+G6BBfayg2cEu4b5Q@mail.gmail.com
Whole thread Raw
In response to JDBC Binary transfer of Arrays  (bubba postgres <bubba.postgres@gmail.com>)
List pgsql-general
After trying out the JDBC4 driver in DBCP, I see that Connection.createArray(...) still just creates a big string under the covers. Is that the expected behavior? Am I doing it wrong?


On Thu, Mar 31, 2011 at 8:04 PM, bubba postgres <bubba.postgres@gmail.com> wrote:
Hello!
In my current application I am sending a lot of data to/from the DB with JDBC, and specifically arrays of Double. (or even Double[][]).
Alas, my current implementation I converts everything into a string representation, which blows my memory out of the water and drops my transaction rate way way down while I spend most of my time working with a StringBuffer.

I note that there is this web page:
http://wiki.postgresql.org/wiki/JDBC-BinaryTransfer

Which makes me think I might be saved. Has anyone used Binary Transfer for Double[] (or other) array data?
Any pointers to some implementation would be great...
Right now I have my own implementation that extends java.sql.Array, and contains the string and a typeName and num.

Regards,
-JD

pgsql-general by date:

Previous
From: Rajasekhar Yakkali
Date:
Subject: Re: Postgres 9.1 - Release Theme
Next
From: Dann Corbit
Date:
Subject: Re: Postgres 9.1 - Release Theme