On Thu, 19 Jul 2007, roman wrote:
> I have a problem with reading big binary data from BYTEA field. I write
> to it about 16MB pdf file (as byte[] array) sucessfully, but when I try
> to read it back I have an exception:
>
> Exception occurred during event dispatching:
> java.lang.OutOfMemoryError: Java heap space
> at org.postgresql.util.PGbytea.toBytes(PGbytea.java:53)
You don't mention what driver version you are using, but 8.2-504 and
higher will be slightly stingier about the amount of memory it uses. You
still need a lot of memory to retrieve large results, but this version is
better.
Kris Jurka