Skip site navigation (1) Skip section navigation (2)

JDBC4 Binary Mode with Arrays

From: bubba postgres <bubba(dot)postgres(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC4 Binary Mode with Arrays
Date: 2011-04-01 18:44:32
Message-ID: BANLkTikvzvn4TFWScamdo6Ps30ef2TTmYA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Sorry for the cross post, I put this on general first:

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[][]).
I have been converting everything into a string representation of the array
with StringBuffer, which eats a lot of memory.

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

Which made me think I might be saved.

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?
Will the String get converted to binary representation again before hitting
the wire?

Regards,
-JD

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2011-04-02 06:43:06
Subject: Re: JDBC4 Binary Mode with Arrays
Previous:From: Maciek SakrejdaDate: 2011-04-01 16:36:01
Subject: Re: JDK1.7 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group