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.postg...@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 >
