Re: JDBC Binary transfer of Arrays

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(dot)postgres(at)gmail(dot)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
>