Retrieving bytea column problem - they're are sometimes truncated

G'day all,

I've been hacking at this all day and have now been through my source and
then the driver source - grokking the entire postgres jdbc driver in the
process ;)

What happens is when I store binary content into a bytea field it works fine
(using setBinaryStream() or setBytes()). I've tested this by looking into
the DB at the actual content itself.

However when I retrive the content, it's sometimes truncated. (It appears to
be for content greater than about 25k but that's a very rough
approximation).

here's a snippet of my debugging code:

org.postgresql.jdbc2.ResultSet.java

if (fields[columnIndex - 1].getPGType().equals("bytea"))
{
String s = getString(columnIndex);
System.out.println("s = " + s);
byte[] result = PGbytea.toBytes(s);
System.out.println("result.length = " + result.length);
return result;
}

the result.length returned (in one example) is 59402 bytes, when the length
of the bytea field is actually 190608 bytes.

printing s to the console indeed reveals that it has been truncated.

(As a test I inserted a list of a few thousand emails addresses in order,
starting from a-z - it gets truncated around f - although the DB has all the
way through to z ;))

I looked deeper into the source for about 30 minutes but got a little lost
in pg_stream in QueryExecutor and figured I'd leave the rest of the
investigation up to the experts!

I couldn't find any related queries in the archives.

Can anyone help? Or provide insight as to where I should start looking?

Cheers,
Mike

Mike Cannon-Brookes :: mike(at)atlassian(dot)com

Atlassian :: http://www.atlassian.com
Supporting YOUR J2EE World