From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Cc: | bubba postgres <bubba(dot)postgres(at)gmail(dot)com> |
Subject: | Re: JDBC4 Binary Mode with Arrays |
Date: | 2011-04-03 20:40:41 |
Message-ID: | 201104032240.41399.rsmogura@softperience.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
bubba postgres <bubba(dot)postgres(at)gmail(dot)com> Friday 01 April 2011 20:44:32
> 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
I developed some experimental driver, with support for binary mode, and it's
only supported mode right now. I'll be glad if You try it:
http://softperience.eu/pages/cmn/ngpgjdbc.xhtml
Regards,
Radoslaw Smogura
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2011-04-03 22:14:18 | experimental Netty-based protocol implementation |
Previous Message | Kris Jurka | 2011-04-02 08:46:18 | Re: PreparedStatement batch statement impossible |